"WITH COMPRESSION" backup option breaks hyperbac 5.2

Silent compression for faster, smaller SQL Server backups

Moderators: eddie davis, Colin Millerchip, fionag

"WITH COMPRESSION" backup option breaks hyperbac 5.2

Postby JesseG » Thu Jul 28, 2011 11:05 pm

(Yes, I know it doesn't make sense to try to compress a compressed backup. We ran across this due to a mis-configured maintenance plan.)

sql 2008 ent, 10.00.4311

Hyperbac is not creating zip files for databases that are using native backup compression.

--works, no compression, neither hyperbac or sql (2 MB)
BACKUP DATABASE myDatabase to DISK = 'i:\\test\\myDatabase1.bak'

--works, hyperbac compression, valid zip file created, inside the zip file is myDatabase.bak (256 KB)
BACKUP DATABASE myDatabase to DISK = 'i:\\test\\myDatabase2.zip'


--works, native sql compressed backup (252 KB)
BACKUP DATABASE myDatabase to DISK = 'i:\\test\\myDatabase3.bak' WITH COMPRESSION

--doesn't work as expected, I expected a valid zip file with a compressed backup inside, instead i got a native sql compressed backup (252 KB)
BACKUP DATABASE myDatabase to DISK = 'i:\\test\\myDatabase4.zip' WITH COMPRESSION

I would consider this a bug, as the options within sql server should have no bearing on how hyperbac does it's job.

thanks
JesseG
 
Posts: 1
Joined: Thu Jul 28, 2011 10:46 pm
Location: Springfield, MO

Postby javen » Sun Jul 31, 2011 9:57 am

Hi,

This is known, there are known compatibility issues with the internal CRC structures in the DEFLATE compression format and the native compressed backup format, we are looking into this, however there is little or no compression benefit in using both native and HyperBac compression for backups, this is not necessarily so however for combining native row and page level compression with SQL Storage Compress data compression. Your post is duly noted however.
Jeffrey Aven
Product Management - HyperBac Technologies
Red Gate Software
javen
 
Posts: 50
Joined: Tue May 25, 2010 12:10 am


Return to SQL HyperBac 5

Who is online

Users browsing this forum: No registered users and 0 guests