How to enable Backup compression on sql server 2008 R2

Backup compression is an interesting feature that was introduced in SQL 2008. To take compressed backups on SQL server first, we need to enable the compression feature on the server level. We can enable backup compression feature in both GUI and command mode too.

Using GUI: Connect to server and right click on server > properties> database settings> just check the box on compress backup. and click on OK to enable backup compression on the SQL server.

Using commands: Below is the command that will help us to enable backup compression on SQL server.

USE master;
GO
EXEC sp_configure 'show advanced option', '1';
RECONFIGURE
GO
EXEC sp_configure 'backup compression default', '1';
RECONFIGURE WITH OVERRIDE;
GO
EXEC sp_configure 'show advanced option', '0';
RECONFIGURE
GO


Source