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
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