Backup History

This is a quick rewrite of the script I just posted a few days ago.  The script had a few flaws if trying to run it on a SQL 2005 box.  I have updated it to run against SQL 2005 and up.

This version is done using Dynamic SQL to help achieve some of the functionality that I wanted but while allowing the flexibility of the different SQL Versions.

You can see the old script here, shown as a part of investigating why differential backups were failing to restore.

 

 

Running the above code, I get the following for one of my SQL instances.

5 thoughts on “Backup History”

  1. Thanks for the update Jason. Shame there’s no way of doing it without resorting to dynamic SQL. Maybe future versions will do late binding down to the statement level 😉

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.