| title | backup checksum default |
|---|---|
| description | Find out about the backup checksum default option. See how to use it to turn backup checksum on or off during SQL Server backup and restore operations. |
| author | rwestMSFT |
| ms.author | randolphwest |
| ms.date | 03/02/2017 |
| ms.prod | sql |
| ms.technology | configuration |
| ms.topic | conceptual |
[!INCLUDE SQL Server]
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.
Enable or Disable Backup Checksums During Backup or Restore (SQL Server)