Backup Checksum Default

This instance does not have backup checksum default set to true. Setting backup checksum default to true enables SQL Server to use checksums to ensure data integrity during backup and restore operations.

Backup checksums are an extra measure to ensure backups are valid and restored are healthy.

Suggested Action

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

Set backup checksum default to true to backup and restore with checksum by default.

How to Configure the Backup Checksum Default for All Databases

EXEC sys.sp_configure N'backup checksum default', N'1';
RECONFIGURE;
GO

How to Perform a Single Backup and Restore With Backup Checksum

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

RESTORE DATABASE [WhippetWorks]
FROM DISK = N'Z:\Backups\WhippetWorks.bak'
WITH CHECKSUM;
GO

Further Reading

Backup Checksum Default | Microsoft Docs

Enable or Disable Backup Checksums During Backup or Restore (SQL Server) | Microsoft Docs