Compressed backup was introduced in SQL Server 2008 Enterprises edition and later only.
EXEC sys.sp_configure N'backup compression default', N'1'
RECONFIGURE WITH OVERRIDE
Once you enable the compressed backup, When you perform the backup next time, The backup will be compressed by default.
Asked In: Many Interviews |