Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Quick question! I heard that we should never shrink our databases. However, does the same rules apply to compressing our SQL backup?

Thanks

share|improve this question
add comment

2 Answers 2

up vote 4 down vote accepted

Backup files are just "data at rest". There's no harm in compressing them. To restore them you'll need to decompress them.

You'll be using some CPU to perform the compression. You might want to compress them on a machine other than the SQL Server computer itself if you're concerned about using its CPU.

share|improve this answer
    
Thanks for the tip! –  user1034912 Feb 9 '12 at 1:51
add comment

Heck yes! Compress away! Best of all possible worlds is to use something like lightspeed or sql 2008 r2 compressed backups to compress.

share|improve this answer
    
Thanks for the tips! –  user1034912 Feb 9 '12 at 1:51
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.