Data decompression error

Dinesh

Hi,

We have a back of one of our production databases (the database size is around 30gb) that is encrypted and broken into 40 files (sqb). When we try to restore the backup in the development servers (diff location, we had to download all the files), we get decryption errors;

Thread 19 error:
Data decompression error: ZLib decompression error: data error

SQL Server error

Server: Msg 3013
RESTORE DATABASE is terminating abnormally.
Server: Msg 3203
Read on "SQLBACKUP_BAACD366-5D5F-4C2B-BCD4-1AC3E418EC0619" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)

SQL Backup exit code: 1100
SQL error code: 3203

We are working on it to see whether the error related to something else. Please check and see whether it is related to the SQLBackup tool.

We use SQLBackup profession edition (v. 4.6.0.815)

Hight appreciate your early reply.

Thanks

Dinesh

petey

It appears that you are using either compression level 2 or 3, and that the files are incomplete. You could generate a hash of the original files and the copied files and compare to see if they are identical.

E.g. an MD5 hash generator can be found here (http://www.yohz.com/downloads/md5x.zip).

Dinesh

Hi Peter,

Thanks for the reply. We found that there is a problem with one file. We downloaded it again and did the restore operation, and it worked.

Thanks again.