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