This blog is part of the blog series named SQL Server Monitoring.
Purpose
To list status of backups.
Sources
This feature queries the MSDB tables dbo.backupmediafamily and dbo.backupset which returns status for the generated backups.
Report
The report has 2 tables, where the upper table are showing the databases for which there has not been performed full, differential or in case of FULL recovery mode log backup within the age specified by the 2 slicers, and the lower table table are showing all backups performed.
Model
The model for the report uses the facts [Backup age] and [Backup status], and the dimensions [Date], [Database] and [Junk dimensions].
Configuration
There is no configuration for this feature.
Scheduling
The default schedule for the feature is every hour (3.600 seconds).
Retention
The default retention for the table dbo.fhsmBackupStatus is 90 days.
Further more there is a retention with the filter “Type = ‘L'” at 7 days to delete records for log backups.
