Export (0) Print
Expand All
1 out of 2 rated this helpful - Rate this topic

Configure Backup Compression (SQL Server)

SQL Server 2012

At installation, backup compression is off by default. The default behavior for backup compression is defined by the backup compression default Option server-level configuration option. However, you can override the server-level default when creating a single backup or scheduling a series of routine backups. To change the server-level default, see View or Configure the backup compression default Server Configuration Option.

You can change the backup compression behavior for an individual backup, backup job, or log shipping configuration.


Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.