1

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

Thanks

user1034912
  • 1,335
  • 3
  • 14
  • 20

2 Answers2

4

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.

Evan Anderson
  • 141,071
  • 19
  • 191
  • 328
2

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

Jim B
  • 23,938
  • 4
  • 35
  • 58