[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Backup Compression

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

Backup Compression Feature

Applies: SQL Server 2008 (Katmai) CTP November 2007, SQL Server 2008 Enterprise Edition


Backup compression is supported only by SQL Server 2008 Enterprise Edition or later, but any edition of SQL Server 2008 can restore a compressed backup.
 




The backup compression feature is off by default in SQL Server 2008. However, you can change this behavior by overriding this server-level configuration option, doing one of the following two procedures:

 

USE master;

GO

EXEC sp_configure ‘backup compression default’, '1';

RECONFIGURE WITH OVERRIDE;








Or go to the Server Properties Dialog

 




On the Database Settings page of the Server Properties dialog, click on the "Compress backup" check box.

 



 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.