ZLib decompression error using sqb2mtf

• 
  Hi,
  
  I see you have run into a known issue with SQL Backup 5.0. SQB2MTF had a problem in that version, so you have two options: you can upgrade to 5.1 (use Check for Updates to do this) or you can convert through SQL Server using the SQLBACKUP stored procedure's CONVERT command. The usage for CONVERT is available in the documentation.
  
  Thanks!

  Brian Donahue June 19, 2007 04:00

  - 0 +
• 
  Thanks for the update.

  lifecDBA June 19, 2007 10:01

  - 0 +
• 
  I have a *.sqb file backed up that I want to restore to a SQL Server that doesn't have SQLBackup installed.
  
  I have tried the backup both with and without encryption, but I get the same error.

  Error converting file: ZLib decompression error: data error
  

  
  Backup details:
  compression level: 2
  Threads: 3
  encryption: tried both with and without.
  
  I am using the sqb2mtf.exe from: http://downloads.red-gate.com/sqb2mtf.zip
  
  located on the utilities page.
  http://www.red-gate.com/support/downloa ... lities.htm
  
  I'm at a loss. Any insight would be much appreciated.

  bdill September 25, 2007 15:50

  - 0 +
• 
  Just as lifecDBA experienced, the GUI version worked for me, but the command line version did not.
  
  GUI: http://labs.red-gate.com/index.php/SQL_ ... _Converter
  
  Is the GUI version using different code? Is there just a bug in the command line version?

  bdill September 25, 2007 16:21

  - 0 +
• 
  Hi all,
  
  If memory serves me, there was a bug in SQB2MTF 5.0 that would behave like this. It was quickly rectified in 5.1. You can download the latest SQB2MTF from Red Gate's utilities and prerequisites page:
  
  http://www.red-gate.com/support/prerequ ... lities.htm

  Brian Donahue September 26, 2007 04:29

  - 0 +
• 
  Unfortunately the version listed on the prerequisities webpage is still the 5.0 version. There are two ways you can get hold of the 5.1 version:
  
  * Install the 5.1 version of SQL Backup, and then you can copy the sqb2mtf.exe file;
  * Alternatively, you can drop me an email (jason.cook@red-gate.com) and I'll send you the 5.1 version.
  
  Jason

  Jason Cook September 26, 2007 06:23

  - 0 +
• 
  Jason C.,
  Thanks I got it. I assumed that the Red-Gate utilities page was the latest version.
  
  The 5.1 version worked just fine. Wag of the finger to RG for not posting the most current version on the website!

  bdill September 26, 2007 10:27

  - 0 +

Add comment

Please sign in to leave a comment.