Still Here and Backing Up

I’ve been spending quite a bit of time in the .NET world lately and haven’t done much on the SQL Server side. But I thought I’d try out the WordPress IPad app to see how it feels. I did have a recent need to supply someone with a report of the backups of a database. I have been using a custom built implementation for log backups using Redgate SQL Backup. Their tool does still keep track of the backups within SQL Server. So I was able to use msdb..backups and other associated tables to create a query to give me the results I needed and even break it out by SQL Server Full backups, Redgate Full backups, and Redgate Log backups.