• eric.lyons (8/28/2012)


    GilaMonster (8/28/2012)


    eric.lyons (8/28/2012)


    8/19/2012 9:51spid17sCHECKDB for database 'NSMRulestat' finished without errors on 2009-09-20 18:00:09.840 (local time).

    8/19/2012 9:51spid25sCHECKDB for database 'Maint' finished without errors on 2012-08-19 03:14:55.117 (local time).

    8/19/2012 9:51spid36sCHECKDB for database 'VisibData' finished without errors on 2012-08-19 03:10:05.883 (local time).

    Look at the highlighted dates.

    Btw, some of your databases have not had a successful checkDB in 3 years, you may want to rectify that.

    Old databases -- has no activity

    Doesn't mean they can't be corrupted due to an IO subsystem glitch. It you absolutely don't care about them at all, fine. If you use them at all, they should still get consistency checks every now and again.

    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