| title | backup checksum default | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/02/2017 | |
| ms.prod | sql | |
| ms.prod_service | database-engine | |
| ms.service | ||
| ms.component | configure-windows | |
| ms.reviewer | ||
| ms.suite | sql | |
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | article | |
| ms.assetid | eef42653-85d0-4eaf-94bd-2ea1b024cd23 | |
| caps.latest.revision | 5 | |
| author | MikeRayMSFT | |
| ms.author | mikeray | |
| manager | craigg | |
| ms.workload | Inactive |
[!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)