DB Integrity & Backup Report

  • Comments posted to this topic are about the item DB Integrity & Backup Report

  • Nice script. However, I found one flaw to it. If you have a database that has never been backed up or had an integrity check run on it it will not show up in this report. I found this because I ran the report then created an empty db and reran it. The new DB will not show up until you run a database backup of it.

  • Good One and thanks for sharing.

    Every thought is a cause and every condition an effect

  • Hmm, thats a great find about db's without backups... I will modify the script and upload a new version! thx!

  • Thanks for the good script.

  • I do like simple status reports like this that are easily emailed, I send myself a summary of my nightly DBCCs and suspect pages. I look at half a dozen lines instead of 150k of results, as long as those half dozen lines are all zeroes.

    Good job!

    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • Nice Nicholas!

    I use similar queries to prioritize what is going to be done during my maintenance windows.

    DBCC CHECK the DBs that haven't been done in a while or ever. Same goes for the restore testing.

    I also setup a "Reporting" sql agent job to send me emails every morning (If needed). One of the steps

    reports missing backups.

    Thanks for sharing!

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply