Restore Error

qafoo

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

Eddie D

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 D

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