Database backups are the foundation of any SQL Server disaster recovery plan. To save storage and improve efficiency, many administrators use compressed backup files. However, these files can ...

SQL Server backup compression is a powerful feature that can significantly reduce backup file sizes, leading to faster backups, quicker restores, and reduced storage consumption. However, like any ...

Using compression with SSMS is just as easy. Simply set the compression option on the Options page of the Back up Database dialog. You may be asking yourself: How effective is this compression? The ...

SQL Server 2008 provides a feature, which, in my opinion, has been far overdue: backup compression. For too long, if you wanted the benefit of compressed backups, you had to look at a third-party tool ...

When the creation and configuration of a Recovery Services vault is complete, discovering databases and configuring backup is a two-step process. During the backup configuration, if the SQL VM and its ...

DATEDIFF(SECOND, bs.backup_start_date, bs.backup_finish_date) AS duration_seconds, CAST(bs.backup_size / 1048576.0 AS DECIMAL(18,2)) AS backup_size_mb, CAST(bs.compressed_backup_size / 1048576.0 AS ...