Redigera

Dela via


Configure Backup Compression (SQL Server)

Applies to: SQL Server

At installation, backup compression is off by default. The backup compression default server-level configuration option sets the default behavior for backup compression. 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.

Use integrated acceleration and offloading

Beginning with SQL Server 2022 (16.x), use Integrated acceleration and offloading to compress backups with Intel® QuickAssist Technology.

Override the Backup Compression Default

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

See Also

Backup Compression (SQL Server)