Quick Scan Report – Excessive Backup History
The threshold for excessive backup history in the Quick Scan Report is greater than 1 year of backup history, or greater than 10,000 rows in the backup history.
SELECT MIN(backup_start_date) AS first_backup, COUNT(*) AS total_rows FROM msdb.dbo.backupset WITH (NOLOCK);
For those who are running frequent transaction log backups, the backup history can grow pretty quick.
To see the backup history:
SELECTÂ * FROM msdb.dbo.backupset WITH (NOLOCK);
Enroll Today!
![SteveStedman5](http://databasehealth.com/wp-content/uploads/2021/10/DHMimage1-1.png)
![SteveStedman5](https://stevestedman.com/wp-content/uploads/2021/03/button-16.png)
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!