jeudi 16 août 2012 08:53
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 .
Toutes les réponses
jeudi 16 août 2012 12:57Auteur de réponse
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.
jeudi 16 août 2012 14:30
Thank you for reply.