Tag: Backup Compression

SQL Server 2008 – Database Backup Compression

SQL, SQL-Advanced, SQL-Backup & Restore, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

Backup compression was introduced in SQL Server 2008 Enterprise. At installation, backup compression default is set to 0, which makes backup compression off by default. To change the default to COMPRESSION, set backup compression default to 1. To revert the default to NO_COMPRESSION, set backup compression default back to 0.

» Read more
, ,