Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 compress backup how much percentage

Author  Topic 

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2011-06-22 : 06:04:16
Hi Team,
i just want to know how much percentage is compressing the new sql server 2008R2 compress backup.

please let me know asap.

thanks in advance

Arnav
Even you learn 1%, Learn it with 100% confidence.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2011-06-22 : 07:08:13
It compresses 42.609340934589 percent!

Not really. It is a vague question. It's like asking "Will I win the lottery this week?".
It depends on your data of course! It depends if you already have enabled row or page compression. It depends if you are using unicode data, or mostly integers/decimals or text.

Why don't you take a backup and test?



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2011-06-22 : 07:09:24
I manage a small datawarehouse of 150GB. After enabling Page compression, the data file shrunk to 30GB.
After backup with compression enabled, the backup file is 17 GB.



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2011-06-22 : 07:24:03
Thanks Peso,
i did a test already, it gave different results for different databases. so to know from the experienced professionsals like you, i asked.

Arnav
Even you learn 1%, Learn it with 100% confidence.
Go to Top of Page
   

- Advertisement -