Options
Restore Problem
Surinder
Posts: 44 Bronze 2
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.
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.
Shin..
Comments
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.
Hi,
Sorry for not getting back to you. This case can be closed, we tracked
the issue down to our SAN.
Thanks,