ZLib decompression error

• 
  Could you please post the contents of the SQL Backup log file for the restore that failed? By default, the log files are stored in C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name>.
  
  Does your SQL Server 2008 database use the new FILESTREAM feature?
  
  Is the backup file the original backup file, or is it a copy? If the latter, could you please check if the file is identical to the original? You could use a md5 file hash generator to generate a checksum.

  petey October 04, 2008 03:51

  - 0 +
• 

  petey wrote:

  Could you please post the contents of the SQL Backup log file for the restore that failed? By default, the log files are stored in C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name>.
  
  Does your SQL Server 2008 database use the new FILESTREAM feature?
  
  Is the backup file the original backup file, or is it a copy? If the latter, could you please check if the file is identical to the original? You could use a md5 file hash generator to generate a checksum.

  
  Here's the log file

  SQL Backup log file 5.3.0.178
  
  -SQL "RESTORE DATABASE [VerticalsLog] FROM DISK = 'D:\Backup\VerticalsLog.sqb' WITH RECOVERY, MOVE 'VerticalsLog' TO 'E:\SQLData\VerticalsLog.mdf', REPLACE "
  

  ---

  ERRORS AND WARNINGS

  ---

  
  
  10/3/2008 2:29:07 PM: Restoring VerticalsLog (database) from:
  10/3/2008 2:29:07 PM: \Backup\VerticalsLog.sqb
  
  10/3/2008 2:29:07 PM: RESTORE DATABASE [VerticalsLog] FROM VIRTUAL_DEVICE = 'SQLBACKUP_570CC681-3C68-44F2-9870-E2005C474C68' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , RECOVERY, MOVE 'VerticalsLog' TO 'E:\SQLData\VerticalsLog.mdf', REPLACE
  
  10/3/2008 2:33:21 PM: Thread 0 error:
  Data decompression error: ZLib decompression error: data error
  Process terminated unexpectedly. Error code: -2139684860
  10/3/2008 2:33:21 PM:
  SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
  SQL error 3183: SQL error 3183: RESTORE detected an error on page (0:0) in database "VerticalsLog" as read from the backup set.

  
  FILESTREAM is Disabled on both the Source server DB and the Destination server DB
  
  The file is the original backup file downloaded via the FTP

  jerryhung October 06, 2008 10:16

  - 0 +
• 
  The SQL Backup error message suggests that the file is corrupted. Could you please download and run this md5 hash generator on both the original backup file, and the file you downloaded, and compare the hash values? Are they equal?

  petey October 06, 2008 22:43

  - 0 +
• 
  Never mind the issue
  
  I re-downloaded a new backup (daily generated)
  MD5 both and they matched
  Restored with SQL Backup, it worked fine
  
  
  Thanks

  jerryhung October 08, 2008 09:53

  - 0 +

Add comment

Please sign in to leave a comment.