backup checksum default

Type: Basic (NEW)

Default value: 0

With SQL Server 2014, you can use the BACKUP and RESTORE Transact-SQL statement WITH CHECKSUM. Doing a checksum verifies the backups file integrity (same size). However, when you install SQL Server 2014, the backup checksum default is set to 0, which makes backup/restore checksum off by default. To change the default to CHECKSUM, you set the backup checksum default to 1. To revert the default to NO_CHECKSUM, set the backup checksum default back to 0.

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.