Comments (6)

  1. […] Day 18 of 31 Days of Disaster Recovery: How to CHECKDB Like a Boss¬†– ¬†Continuing his excellent series it’s Robert L. Davis(Blog|Twitter). Here he shares a script for us to put to work. […]

  2. Hi,
    Thanks for a great set of scripts. I have a question though: when I execute dba_CHECKDBLikeABoss ande let it default to NUll (so I can have it iterate through all the databases, I see an error: Msg 50000, Level 16, State 1, Procedure dba_CHECKDBLikeABoss, Line 93
    DBCC CHECKDB failed for the following databases: (null). Check dbo.CHECKDBResults for more information. The CHECKDBResults table is empty.
    Am I doing something wrong? Thanks.

    1. Thanks for catching and reporting this! I tested it with a wide variety of errors, but the one thing I forgot to test it with is what if there are no failures. It’s raising the error at the end even if there are no failures detected.

      I have uploaded a new version of the procedure that returns a successful message if no errors are found.

      Thanks again for your help!

Leave a Reply

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