Data Backup and Recovery

SMSQL - Snap restore error - cannot find snapinfo file

thaddad
4,116 Views

We have been using Snapmanager for SQL for some time and restoring/cloning a snapshot from production to a developement host with no issues. Just recently we are receiving this messages after it mounts the LUN on the target SQL host (instance). Attached is the full SQL restore log.   At the top of the log file is the versioning of Windows and SMSQL we are using..

 

Database administrator attempted a restore from production to production (same host), it works fine.    

 

Any ideas?

 

SQLUAT1]
[SQLUAT1] Unable to find the snapinfo file at path:
[SQLUAT1] S:\SQLSPSNAPS\MPDISK001\SMSQL_SnapInfo\VDISK__MountPoint-002\FG__\01-04-2016_02.01.26__Daily\SnapInfo__01-04-2016_02.01.26.sml
[SQLUAT1] Retrying to locate the snapinfo file...
[SQLUAT1] Cannot find the SnapInfo file at path:
[10:55:18.313]  [SQLUAT1] S:\SQLSPSNAPS\MPDISK001\SMSQL_SnapInfo\VDISK__MountPoint-002\FG__\01-04-2016_02.01.26__Daily\SnapInfo__01-04-2016_02.01.26.sml
[SQLUAT1] Retrying to locate the snapinfo file...

[10:55:51.376]  [SQLUAT1] *** SNAPMANAGER MOUNT BY RESTORE (CLONE) JOB ENDED AT: [01-04-2016 10.55.18]

[SQLUAT1] Error Code: 0xc004087c
Unable to find the snapinfo file from the mounted LUN in snapshot that contains the most recent snapinfo directory information.

3 REPLIES 3

thaddad
4,106 Views

let me add that production instance runs on virtual machine SQLVM01 while dev/uat instances run on SQLVM02. All supported on Windows 2012 using ISCI protocol.

Sahana
4,068 Views

Hi,

 

Please check this bug : http://mysupport.netapp.com/NOW/cgi-bin/bol?Type=Detail&Display=847188

If required please contact NetApp Support for assistance in obtaining the SMSQL 7.1 P1 patch release 

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.

thaddad
4,060 Views

The restore is attempting to use the latest snapshot as selected by the SQL administrator.

We have restored in this manner for a good amount time now but last restore attempt (again using latest snapshot) produced the error described about the "snapinfo file...'.

Public