There are 2 methods to apply the compression as the default option for Microsoft SQL Server. Before you perform the change, use the following query to see if the compression is enabled or not.
SELECT value
FROM sys.configurations
WHERE name = 'backup compression default' ;
GO
Method 1
Using Microsoft SQL Server Studio, right click on database server and choose Properties.
Jump to Database Settings and check the Compress backup setting. Click OK to apply the changes.
Method 2
Use the following query,
EXEC sp_configure 'backup compression default', 1 ;
RECONFIGURE;
GO
