--- title: "backup checksum default | Microsoft Docs" ms.custom: "" ms.date: "03/02/2017" ms.prod: "sql-server-2016" ms.reviewer: "" ms.suite: "" ms.technology: - "dbe-backup-restore" ms.tgt_pltfrm: "" ms.topic: "article" ms.assetid: eef42653-85d0-4eaf-94bd-2ea1b024cd23 caps.latest.revision: 5 author: "JennieHubbard" ms.author: "jhubbard" manager: "jhubbard" --- # backup checksum default [!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx_md](../../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.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. ## See Also [Enable or Disable Backup Checksums During Backup or Restore (SQL Server)](../../relational-databases/backup-restore/enable-or-disable-backup-checksums-during-backup-or-restore-sql-server.md)