Configure Backup Compression (SQL Server)


Applies To: SQL Server 2016

At installation, backup compression is off by default. The default behavior for backup compression is defined by the backup compression default Option server-level configuration option. However, you can override the server-level default when creating a single backup or scheduling a series of routine backups. To change the server-level default, see View or Configure the backup compression default Server Configuration Option.

You can change the backup compression behavior for an individual backup, backup job, or log shipping configuration.


Backup Compression (SQL Server)

Community Additions