• opc.three (7/20/2012)


    If dbi_dbccFlags = 1 then it has never run clean.

    That just tells you whether data purity checks have ever been run and return clean, not if CheckDB has. If the DB was upgraded from 2000, it's possible for that to be 0 even with a clean checkDB having been completed a second earlier.

    To see when CheckDB last ran without error, look at the dbi_dbccLastKnownGood which is the date that CheckDB last ran without error. If it's 1900..., the answer is Never.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass