compress backup file

Sql Server Backup Compression

SQL Server Backup Compression is a feature that was introduced in SQL Server 2008 that provides a method of compressing the data in a SQL Server backup file. This can result in a significant reduction in the size of the backup file, which can be important if you need to store the backups off-site or on a slower media.

The compression process is implemented using a technology called gzip, which is the same compression technology that is used by the …