backup checksum default

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Use the backup checksum default setting to enable or disable backup checksum during backup and restore.

The possible values are described in the following table:

Value Meaning
0 Disabled. This is the default setting.
1 Enabled

The setting takes effect immediately.

See Also

Enable or Disable Backup Checksums During Backup or Restore (SQL Server)