| title | backup checksum default | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 2017-03-02 | |
| ms.prod | sql-server-2016 | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | article | |
| ms.assetid | eef42653-85d0-4eaf-94bd-2ea1b024cd23 | |
| caps.latest.revision | 5 | |
| author | JennieHubbard | |
| ms.author | jhubbard | |
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-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)