Microsoft SQL Server Enable backup compression default


Example

Exec sp_configure 'backup compression default',1
GO  
RECONFIGURE;