Red Gate forums :: View topic - Restore Error
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 Error

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



Joined: 09 Jun 2008
Posts: 5

PostPosted: Thu May 08, 2014 11:39 am    Post subject: Restore Error Reply with quote

Hi,

I'm trying to estore from production to Dev environment i get the following error.

----------------------------Error Start------------------------------------

Restoring full backup - Failed
------------------------------

This operation failed with errors.

Restoring CRM (database) from:
C:\Mydblocationo\FULL_(local)_CRM_20140508_094339.sqb
Thread 0 error:
Failed to service command. Error code: -2139684860
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
Thread 1 error:
Failed to service command. Error code: -2139684860
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
Thread 2 error:
Data decompression error: ZLib decompression error: buffer error
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
SQL error 3241: SQL error 3241: The media family on device 'SQLBACKUP_4385AEBF-2808-4045-9CEE-D837716BD52202' is incorrectly formed. SQL Server cannot process this media family.
SQL error 3203: SQL error 3203: Read on "SQLBACKUP_4385AEBF-2808-4045-9CEE-D837716BD522" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)
SQL Backup exit code: 790
SQL error code: 3203



Updating SQL Server information - Pending
-----------------------------------------

Operation pending.


----------------------Error End----------------------------
Version - 7.6.0.26

I've tried both application and converter no dice..

Thank you
_________________
Life is plain and simple
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 936
Location: Red Gate Software

PostPosted: Fri May 09, 2014 4:35 pm    Post subject: Reply with quote

Thank you for your forum post and sorry that you have encountered a problem.

It looks like that the compression components within SQL Backup have failed to decompress the backup file.

If you have a tight deadline to meet and need to get this restored, there is a stand-alone version of the conversion tools available HERE.

Does this occur for every backup file you attempt to restore on this server?

Was the backup file copied from the Production Server to the Dev environment?

You can use the SQL Backup Testing Utilities which can be downloaded using this LINK.

From tools menu there is a file integrity checker and a MD5 hash generator. You ensure that the backup file is OK and if the backup file was copied create a hash code of the original and copied file, if the hashes do not match I suspect the copied file has corrupted.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
eddie davis



Joined: 14 Jun 2006
Posts: 936
Location: Red Gate Software

PostPosted: Thu May 29, 2014 2:43 pm    Post subject: Reply with quote

Further update to my reply of the 9th May 2014.

The situation described in this forum post is very rare. From my experiences supporting SQL Backup, this problem occurs when manually copying files from one location to another, normally between different physical machines.

If the user does encounter this problem, you can use the SQL Backup Testing Utilities to check the file integrity of the copied file and to generate a MD5 hash of the copied file, generate MD5 hash of the original backup file and compare the hash codes. If there is a mismatch in the MD5 hash code, the copied file is most likely corrupted.

Retry the manual copy process, or use an alternative copying tool.

If you still continue to encounter problems, please send an email to the Red Gate Support team [support@red-gate.com] and create a support ticket.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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