| title | backup checksum default | Microsoft Docs |
|---|---|
| ms.custom | |
| ms.date | 03/02/2017 |
| ms.prod | sql |
| ms.prod_service | database-engine |
| ms.reviewer | |
| ms.suite | sql |
| ms.technology | configuration |
| ms.tgt_pltfrm | |
| ms.topic | conceptual |
| ms.assetid | eef42653-85d0-4eaf-94bd-2ea1b024cd23 |
| caps.latest.revision | 5 |
| author | MikeRayMSFT |
| ms.author | mikeray |
| manager | craigg |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]
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)