| title | backup checksum default | Microsoft Docs |
|---|---|
| ms.custom | |
| ms.date | 02/29/2016 |
| ms.prod | sql-server-2014 |
| ms.reviewer | |
| ms.topic | conceptual |
| ms.assetid | a3b70885-47d7-4bd0-b28b-5a44947ae83c |
| author | mashamsft |
| ms.author | mathoma |
| manager | craigg |
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)