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 ...