SQL Hyperbac FILESTREAM compression

Silent compression for faster, smaller SQL Server backups

Moderators: eddie davis, Colin Millerchip, fionag

SQL Hyperbac FILESTREAM compression

Postby electricsk8 » Mon Apr 04, 2011 3:42 pm

Good morning. I'm currently evaluating the SQL Hyperbac 5 application against a database that utilizes FILESTREAM storage for storing documents. Most of the database backup (approximately 99%) is comprised of the documents stored in the FILESTREAM data store. I was hoping for a good backup compression ratio, but only noticed about an 8% compression ratio.

My understanding is that the compression ratio is based upon the ability of the data to be compressed, but using this product in the past, saw a much better compression ratio (50% to 75%) then.

Is there anything that I might be missing?

Thank you for your assistance.
Sean Fitzgerald
electricsk8
 
Posts: 2
Joined: Mon Apr 04, 2011 3:31 pm

Postby javen » Mon Apr 04, 2011 8:32 pm

Hi Sean,

Compression is entirely data composition dependent. This particular data is less compressible than your typical tabular, relational data. You would likely see the same or similar compression yield regardless of which product you used.
Jeffrey Aven
Product Management - HyperBac Technologies
Red Gate Software
javen
 
Posts: 50
Joined: Tue May 25, 2010 12:10 am

Postby electricsk8 » Mon Apr 04, 2011 9:09 pm

Thanks for the clarification, that's what I expected.
electricsk8
 
Posts: 2
Joined: Mon Apr 04, 2011 3:31 pm


Return to SQL HyperBac 5

Who is online

Users browsing this forum: No registered users and 0 guests