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.
To override the server backup-compression default when creating a backup, use either WITH NO_COMPRESSION or WITH COMPRESSION in you BACKUP statement.
For a log shipping configuration, you can control the backup compression behavior of log backups by using sp_add_log_shipping_primary_databasesp_change_log_shipping_primary_database (Transact-SQL).
SQL Server Management Studio
For information about how to view or configure the backup compression default option for an instance of SQL Server, see View or Configure the backup compression default Server Configuration Option.
You can override the server backup-compression default when creating a backup by specifying Compress backup or Do not compress backup in any of the following dialog boxes:
When backing up a database, you can control backup compression for an individual database, file, or log backup.
The Maintenance Plan Wizard enables you to control backup compression for each set full or differential database backups or log backups that you schedule.
Integration Services (SSIS) Back Up Database task
You can control the backup compression behavior when creating a package for backing up a single database or multiple databases.
You can control the backup compression behavior of log backups.