Tuesday 4 March 2014

Use below code to change default backup setting to compress for a SQL Server:

EXEC sys.sp_configure N'backup compression default', N'1'
GO
RECONFIGURE WITH OVERRIDE
GO

Alternately you can perform same operation from GUI by navigating to following path:

Open Properties of the Server à Select Database Setting Page à Check Compress Backup option.

Note: Backup compression is available in only SQL 2008 Enterprise edition onwards.

No comments:

Post a Comment