Backup History

Categories: Corner, News, Professional, Scripts, SSC
Comments: 5 Comments
Published on: November 30, 2012

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 Comments - Leave a comment
  1. James Lean says:

    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 😉

  2. CodePro says:

    A snap of the output would be useful.

  3. AZJim says:

    Thank you. This is very clean and clear.

Leave a comment

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

November 2012
« Oct   Dec »


  • @tjaybelt: #sqlhelp I need a hadoop hdinsight expert that can help me troubleshoot some immediate issues i am having. We can pay.
  • @SQLKohai: Am I missing a cool SSDT plugin or is it impossible to get an full error except by copying the text and pasting into notepad? #sqlhelp
  • @SQLSoldier: @briancarrig Same as a table. Only if workload/activity warrants it. #sqlhelp
  • @briancarrig: Is a dedicated filegroup for service broker queues a recommended best practice? #sqlhelp
  • @mrdenny: @whoisyarad you mean to remove a column from a table? ALTER TABLE MOCK_DATA DROP COLUMN {ColumnName}; #sqlhelp
  • @whoisyarad: How do i delete column within SQL? SELECT * FROM Practice.dbo.MOCK_DATA Then Replaced the Select with delete #sqlhelp
  • @SQLHA: @kleegeek It's pretty hard to do that. I have yet to find a consistent way. #sqlhelp
  • @kleegeek: Looking for a reliable way to trigger a BSOD on Win2012R2 for some availability testing. Any ideas? #sqlhelp
  • @SqlrUs: @SQLChao Password manager/generator with complex passwords. #sqlhelp
  • @SQLChao: How do you come up with your passwords for service accounts? #sqlhelp

Welcome , today is Monday, November 30, 2015