Red Gate forums :: View topic - "WITH COMPRESSION" backup option breaks hyperbac 5.2
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL HyperBac 5
SQL HyperBac 5 forum

"WITH COMPRESSION" backup option breaks hyperbac 5.2

Search in SQL HyperBac 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
JesseG



Joined: 28 Jul 2011
Posts: 1
Location: Springfield, MO

PostPosted: Thu Jul 28, 2011 11:05 pm    Post subject: "WITH COMPRESSION" backup option breaks hyperbac 5.2 Reply with quote

(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
Back to top
View user's profile Send private message
javen



Joined: 25 May 2010
Posts: 50

PostPosted: Sun Jul 31, 2011 9:57 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group