Backup Compression Default

By default, the option to compress backups is disabled. Enabling this can dramatically increase the speed of backups and reduce the size of the backup files. CPU usage will increase when creating a compressed backup.

Suggested Action

šŸ’” Aireforge Advisor can automatically generate a script for this.

Enable the backup compression setting.

How to Configure the Default Backup Checksum

USE [master]
GO
EXEC sys.sp_configure @configname = N'backup compression default',
                      @configvalue = N'1';
RECONFIGURE;
GO

How to Perform a Single Backup With Backup Compression

BACKUP DATABASE [WhippetWorks]
TO  DISK = N'Z:\Backups\WhippetWorks.bak'
WITH COMPRESSION;
GO

Further Reading

Backup Compression (SQL Server) | Microsoft Docs

View or Configure the Backup Compression Default Server Configuration Option | Microsoft Docs