Post reply

DB Integrity & Backup Report

  • June 29, 2015 at 6:17 pm

    #298190

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

  • July 23, 2015 at 9:20 am

    #1814431

    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.

  • July 23, 2015 at 3:31 pm

    #1814595

    Good One and thanks for sharing.

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

  • July 27, 2015 at 5:59 am

    #1815093

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

  • July 28, 2015 at 7:36 am

    #1815406

    Thanks for the good script.

  • July 28, 2015 at 10:01 am

    #1815478

    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]

  • August 10, 2015 at 5:00 am

    #1818479

    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