Wednesday, April 15, 2009

SQL 2008 : Backup Compression Default

Set server option to turn on sql 2008 backup compression by default...


USE master;
GO
EXEC sp_configure 'backup compression default', '1';
GO
RECONFIGURE WITH OVERRIDE;
GO

No comments: