Red Gate forums :: View topic - Restore Problem
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Restore Problem

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Surinder



Joined: 05 Feb 2007
Posts: 31
Location: Birmingham, UK

PostPosted: Fri Sep 14, 2012 8:24 am    Post subject: Restore Problem Reply with quote

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..
Back to top
View user's profile Send private message
RajK



Joined: 02 Feb 2012
Posts: 58

PostPosted: Mon Sep 17, 2012 10:09 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
RajK



Joined: 02 Feb 2012
Posts: 58

PostPosted: Tue Sep 25, 2012 3:02 pm    Post subject: Reply with quote

-- 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,
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group