Backup Checksum Default Set to Off
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.
💡 Select 'Suggested Script' for an automatically generated script.
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
Backup Checksum Default | Microsoft Docs