Introduction

The backup compression default option determines whether the server instance creates compressed backups by default. When SQL Server is installed, the backup compression default option is off.

Problem

Enable backup compression

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_change_server_backup_compression.sql

Based on https://blog.sqlauthority.com/2015/09/04/sql-server-configure-the-backup-compression-default-server-configuration-option/