Red Gate forums :: View topic - Not seeing the compression I would expect
Return to www.red-gate.com RSS Feed Available

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

Not seeing the compression I would expect

Search in SQL Storage Compress 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
danv@people20.com



Joined: 07 Dec 2009
Posts: 1

PostPosted: Fri Nov 12, 2010 12:31 am    Post subject: Not seeing the compression I would expect Reply with quote

I currently own SQL Backup Professional 6 and normally see a compression size of a 72GB database (52G mdf, 20GB ldf) to 29GB. Most of the compression comes from the empty space.

When I installed the Storage product and restore the SQB backup file to an mdfx and ldfx, I ended of with a 42GB total file size (ldfx was 128mb). Most of compress appears again that it's mostly due the fact that mdf has about 6GB of free space and most (if not all) of 20GB ldf is also free space. At the end of the days that means I'm only realizing 4-6GB of actual compression.

Why am I not seeing more compression from the product similar to 29GB size of the SQB file?
_________________
Dan V, P20 Global
Back to top
View user's profile Send private message
tiestvilee



Joined: 12 Oct 2010
Posts: 5

PostPosted: Thu Feb 24, 2011 3:02 pm    Post subject: Reply with quote

Hi Danv,

I don't quite get where you're numbers are coming from - could you clarify for me?

Original Backup File - 29GB
ldfx - 128MB
mdfx - ??MB <- should be about the same as ldfx

(If you have other ldfx/ndfx/mdfx files for this DB, please include those)

Is your mdfx ending up 42GB big? Where are you getting that number from?

Are you restoring your backup to a more recent version of SQL Server? When 'upgrading' a database like that, there end up being a lot of writes, which results in the 'upgraded' database being quite large when using SVR.
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