Restore Problem

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Restore Problem

Postby Surinder » Fri Sep 14, 2012 8:24 am

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.
Shin..
Surinder
 
Posts: 31
Joined: Mon Feb 05, 2007 12:49 pm
Location: Birmingham, UK

Postby RajK » Mon Sep 17, 2012 10:09 am

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
 
Posts: 58
Joined: Thu Feb 02, 2012 8:21 am

Postby RajK » Tue Sep 25, 2012 3:02 pm

-- 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,
RajK
 
Posts: 58
Joined: Thu Feb 02, 2012 8:21 am


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests