Restore Problem

Surinder

Hi,

I am trying to restore our SharePoint database, which is ~650GB

The restore keeps on failing with the error below.

I suspect it struggling to maintain a connection to teh share where the backup is located. Has anyone come across this error before?

regards,
Surinder

SQL Backup log file 7.1.0.72

-SQL "RESTORE DATABASE [WSS_Content_80] FROM DISK = '\\sharepointdbsql\Backups\RedGateSQLBackups\SQLBackups\WSS_Content_80\FULL_(local)_WSS_Content_80_20120909_040350.sqb' WITH RECOVERY, MOVE 'WSS_Content_80' TO 'D:\Program Files\Microsoft SQL
Server\MSSQL10.MSSQLSERVER\MSSQL\Data\WSS_Content_80.mdf', MOVE 'WSS_Content_80_log' TO 'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data\WSS_Content_80_log.LDF', REPLACE, ORPHAN_CHECK "

---

ERRORS AND WARNINGS

---

13/09/2012 16:44:03: Restoring WSS_Content_80 (database) from:
13/09/2012 16:44:03: \\sharepointdbsql\Backups\RedGateSQLBackups\SQLBackups\WSS_Content_80\FULL_(local)_WSS_Content_80_20120909_040350.sqb

13/09/2012 16:44:03: RESTORE DATABASE [WSS_Content_80] FROM VIRTUAL_DEVICE = 'SQLBACKUP_8A43333E-1C28-4CAF-AB6E-A1420C5B7F29', VIRTUAL_DEVICE = 'SQLBACKUP_8A43333E-1C28-4CAF-AB6E-A1420C5B7F2901', VIRTUAL_DEVICE = 'SQLBACKUP_8A43333E-1C28-4CAF-AB6E-A1420C5
B7F2902' WITH BUFFERCOUNT = 18, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , RECOVERY, MOVE 'WSS_Content_80' TO 'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data\WSS_Content_80.mdf', MOVE 'WSS_Content_80_log' TO 'D:\Program
Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data\WSS_Content_80_log.LDF', REPLACE

13/09/2012 23:12:28: Thread 0 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
EOF#2 validation failed. Device 0. Expected 1041003, available 488672. Error 0 (The operation completed successfully.).
13/09/2012 23:12:28:
13/09/2012 23:12:28: Thread 1 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
EOF#2 validation failed. Device 0. Expected 1041003, available 488672. Error 0 (The operation completed successfully.).
13/09/2012 23:12:28:
13/09/2012 23:12:28: Thread 2 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
EOF#2 validation failed. Device 0. Expected 1041003, available 488672. Error 0 (The operation completed successfully.).
13/09/2012 23:12:28:
13/09/2012 23:12:29: SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
13/09/2012 23:12:29: SQL error 3203: SQL error 3203: Read on "SQLBACKUP_8A43333E-1C28-4CAF-AB6E-A1420C5B7F29" failed: 38(failed to retrieve text for this error. Reason: 15105)
13/09/2012 23:12:29: Warning 204: ReadFile failed for file: \\sharepointdbsql\Backups\RedGateSQLBackups\SQLBackups\WSS_Content_80\FULL_(local)_WSS_Content_80_20120909_040350.sqb at position: 83652773888
13/09/2012 22:14:58: Re-attempt: 1
13/09/2012 22:14:58: File (\\sharepointdbsql\Backups\RedGateSQLBackups\SQLBackups\WSS_Content_80\FULL_(local)_WSS_Content_80_20120909_040350.sqb) reopened and read succeeded (524288 bytes) at position (83652773888).
ReadFile failed for file: \\sharepointdbsql\Backups\RedGateSQLBackups\SQLBackups\WSS_Content_80\FULL_(local)_WSS_Content_80_20120909_040350.sqb at position: 86299379712
13/09/2012 22:20:56: Re-attempt: 2
13/09/2012 22:21:18: File (\\sharepointdbsql\Backups\RedGateSQLBackups\SQLBackups\WSS_Content_80\FULL_(local)_WSS_Content_80_20120909_040350.sqb) reopened and read succeeded (524288 bytes) at position (86299379712).
ReadFile failed for file: \\sharepointdbsql\Backups\RedGateSQLBackups\SQLBackups\WSS_Content_80\FULL_(local)_WSS_Content_80_20120909_040350.sqb at position: 107550869504
13/09/2012 23:07:57: Re-attempt: 3
13/09/2012 23:07:57: OpenTargetFile.CreateFile error: The network path was not found.

13/09/2012 23:08:27: Re-attempt: 4
13/09/2012 23:08:48: OpenTargetFile.CreateFile error: The network path was not found.

13/09/2012 23:09:18: Re-attempt: 5
13/09/2012 23:09:18: OpenTargetFile.CreateFile error: The network path was not found.

13/09/2012 23:09:48: Re-attempt: 6
13/09/2012 23:10:09: OpenTargetFile.CreateFile error: The network path was not found.

13/09/2012 23:10:39: Re-attempt: 7
13/09/2012 23:10:39: OpenTargetFile.CreateFile error: The network path was not found.

13/09/2012 23:11:09: Re-attempt: 8
13/09/2012 23:11:28: OpenTargetFile.CreateFile error: The network path was not found.

13/09/2012 23:11:58: Re-attempt: 9
13/09/2012 23:11:58: OpenTargetFile.CreateFile error: The network path was not found.

13/09/2012 23:12:28: Re-attempt: 10
13/09/2012 23:12:28: OpenTargetFile.CreateFile error: The network path was not found.

RajK

I am the support engineer that is investigating this issue you have raised. I am sorry you have encountered this error and apologise for the inconvenience caused.

Is it possible to let me know a few things about this system? I am after the following information:

1) Has SQL Backup restored this backup successfully before?
2) This problem seems to be related to the network connection on this system. The error message mentions a number of attempts by sql backup to try to keep the connection alive before giving up?
3) Are there any logs being created that correspond to this error in the SQL Backup logs directory other than the error message that you have attached?
4) Is it possible to have a quick look in the server's system log to see if there was any problems with the network connection?

This forum thread has opened a support request and I will continue to work with you via the support request after this email.

Thanks for your feedback in this matter.

RajK

-- Response from the customer:

Hi,



Sorry for not getting back to you. This case can be closed, we tracked
the issue down to our SAN.



Thanks,