Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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


share|improve this question
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

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

Your Answer


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.