June 7, 2011 at 5:09 am
Hi
Backup Compression was newly introduced in 2008.can i know the how much percentage will reduce the backup compression on the backup size.
June 7, 2011 at 5:38 am
Get a trial of sql 2008 R2 and run compression (you don't have that proc in 2005 so you just have to get 2008 to do this).
There's a proc that estimates this. But in my case just telling the server to go ahead and do it was simpler. I did both page compression and backup compression. The final backup was ±75% smaller than the uncompressed backup / data version. Tho keep in mind that our DB doesn't have any nulls and all columns have defaults ('', 0 and 1753-01-01).
http://msdn.microsoft.com/en-us/library/cc280574.aspx
Edited 75%.
June 7, 2011 at 6:35 am
Piling on, but same thing, you won't know for sure how much compression you get for sure unless you use it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply