How to enable compressed backup ?

 Posted by PandianS on 10/31/2010 | Category: Sql Server Interview questions | Views: 2269 | Points: 40
Answer:

Compressed backup was introduced in SQL Server 2008 Enterprises edition and later only.
EXEC sys.sp_configure N'backup compression default', N'1'

GO
RECONFIGURE WITH OVERRIDE
GO
Once you enable the compressed backup, When you perform the backup next time, The backup will be compressed by default.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response