CODEWITHSUNDEEP
sql-servercompressionbackup
MrTelly
MrTelly

Reputation: 14865

Sql Server Backup Sizes

Does anyone have real world experience of backup compression in Sql 2008, I'd like to know how it performs compared to Sql 2005 + winrar. Currently when I back up a I get a 14G file. Using rar shrinks it to <400M, a massive saving. Most of the data is similar, being figures from the stock market so I guess that makes it easy to compress.

Upvotes: 1

Views: 726

Answers (3)

SqlACID
SqlACID

Reputation: 4014

I've got one that goes from 200GB down to 50GB, definitely not as compact as WinRar is getting you, but a lot more convenient. As others have noted, backup time is quicker, but restore time is (a bit) longer but still way quicker than SQL2000.

Upvotes: 0

Mitch Wheat
Mitch Wheat

Reputation: 300529

The figures I have seen suggest compression ratios in the range 3 - 4.5 times smaller, which is not as good as the figures you quoted for rar. See Tuning the Performance of Backup Compression in SQL Server 2008.

On a side note, creating compressed backups is faster.

Upvotes: 1

user67999
user67999

Reputation: 331

Time to restore is an important thing for backups. If you compress your backups, you will spent more time to restore it.

Upvotes: 0

Related Questions