Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Chad Miller

Chad Miller is a Senior Manager of Database Administration at Raymond James Financial. Chad has worked with Microsoft SQL Server since 1999 and has been automating administration tasks using Windows Powershell since 2007. Chad is the Project Coordinator/Developer of the Powershell-based Codeplex project SQL Server PowerShell Extensions (SQLPSX). Chad leads the Tampa Powershell User Group and is a frequent speaker at users groups, SQL Saturdays and Code Camps.

SQLServerCentral Article on Backup Monitoring and Reporting

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.

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.