• MyDoggieJessie (8/24/2013)


    so it's basically reading it from the last known outcome of the prior CHECKDB that was successful.

    Correct. It's printing out the date and time last known good CheckDB run. In the case of the one I listed, I haven't run a CheckDB on that database in a year (it is a test database)

    That info is stored in the database's boot page and printed out whenever SQL brings the DB online (service start, restore, attach, set online)

    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