Database backup compression

Question

Hi Team,

I have some query regarding database backup compression . So is it a best practice to compress database backup alway in production environment or not...

Please clear my dowbt .

 

---

Asheesh pandey

Answer 1

Hello Asheesh,

Personally I would. The amount of CPU overhead is fairly small for compressed backups, and the benefit is less IO and less overall space used. Any edition of SQL Server that is the same version can restore the backup, that shouldn't be a limiting factor.

Based on the above, unless your server is CPU bound I would enable server wide.

-Sean

---

Sean Gallardy, MCC | Blog | Twitter

Answer 2

Thank you for reply.

---

Asheesh pandey