DB Integrity & Backup Report

  • zNick

    SSC Eights!

    Points: 842

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

  • Summer90

    SSC-Dedicated

    Points: 32844

    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.

  • Naidu PK

    SSCrazy

    Points: 2448

    Good One and thanks for sharing.

    Thanks,
    Naveen.
    Every thought is a cause and every condition an effect

  • zNick

    SSC Eights!

    Points: 842

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

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the good script.

  • Wayne West

    SSC-Insane

    Points: 22586

    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]

  • DennisPost

    SSCrazy

    Points: 2691

    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 7 (of 7 total)

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