backup compression default
Type: Basic
Default value: 0
With SQL Server 2012 Enterprise, you can use the BACKUP
Transact-SQL statement to select the backup compression setting to use WITH COMPRESSION
or WITH NO_COMPRESSION
. However, when you install SQL Server 2012, the backup compression default is set to 0
, which makes backup compression off by default. To change the default to COMPRESSION
, you set the backup compression default to 1
. To revert the default to NO_COMPRESSION
, set the backup compression default back to 0
.
From a performance point of view, compression can significantly increase CPU usage, and the additional CPU consumed by the compression process might impact concurrent operations. Therefore, you might want to create low-priority ...
Get Microsoft® SQL Server 2012 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.