Red Gate forums :: View topic - SQL Hyperbac FILESTREAM compression
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

SQL Hyperbac FILESTREAM compression

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



Joined: 04 Apr 2011
Posts: 2

PostPosted: Mon Apr 04, 2011 3:42 pm    Post subject: SQL Hyperbac FILESTREAM compression Reply with quote

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



Joined: 25 May 2010
Posts: 50

PostPosted: Mon Apr 04, 2011 8:32 pm    Post subject: Reply with quote

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



Joined: 04 Apr 2011
Posts: 2

PostPosted: Mon Apr 04, 2011 9:09 pm    Post subject: Reply with quote

Thanks for the clarification, that's what I expected.
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