Home Forums SQL Server 2005 SQL Server 2005 Strategies How disable DBCC CHEKCDB command RE: How disable DBCC CHEKCDB command

  • August 28, 2012 at 2:14 pm

    #1531074

    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.

    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