The article, Backup Monitoring and Reporting, demonstrates a SQL Server backup reporting solution I use in my production environment. Some highlights of the solution:
- Powershell is used to collect backup information from a list of SQL Servers which is loaded into a consolidated reporting database
- A series of queries are used to look for missing backups and report various backup completion statistics
- Using SQL Server Reporting Services (SSRS) is quick way to provide self-service reports and several SSRS reports are included.
See the full article for details.