Introduction

Use the backup checksum default setting to enable or disable backup checksum during all backup and restore operations at the instance level.

Problem

Change default setting to enable or disable backup checksum during all backup

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_change_server_backup_checksum.sql

Example:

Based on https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/backup-checksum-default?view=sql-server-ver16