The Quick Scan report in Database Health Monitor detects when you are performing SQL Server backups without compression, when the compression option is available. This applies to Full backups, Transaction log backups and Differential backups.
Not using compressed backups? Why not?
Benefits of compressed backups
- Faster backup time
- Faster restore time
- Less I/O at backup and restore time
- Since you are using less disk space, you can keep more backups around.
There are a couple minor drawbacks, the compressed backups take more CPU, not much more, but a tiny bit more. Also the compressed backups don’t compress very much when your database is using Transparent Data Encryption (TDE).
Configuring Compressed Backups
To configure compressed backups, locate the backup job in your maintenance plans, and you will see one of the following dialogs depending on your version of SQL Server.
For SQL Server 2008R2 to SQL Server 2012, it will look like this.
For SQL Server 2014 or newer you will see this screen:
Once you enable compressed backups you can check in on the Database Health Monitor Backup report after the next backup has been run to confirm that compression is being used.
- Database Health Monitor Backup report
- Database Health Monitor Download
- Stedman Solutions, SQL Server Consulting
- Quick Scan Report
Stedman Solutions, the provider of the Database Health Monitor Application offers consulting solutions, and can help with getting your backups and restores, or any other database administration issues you may have.