CHECKDB In SQL Logs

• Roger Abram

  Hall of Fame

  Points: 3683

  More actions

  February 12, 2010 at 5:46 am

  #156668

  I have database maintenance scheduled on databases for 7:00 p.m. each night. However, in looking at the SQL logs, I noticed entries that "CHECKDB for database 'database name' finished without errors on date/time" that don't correspond with the maintenance schedule. This happens either in the morning or mid-afternoon.

  What would trigger this to run if it's not part of the scheduled maintenance plan?

  Thanks.

  Roger

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  February 12, 2010 at 6:23 am

  #1117980

  does this coincide with a 'starting up database' message?.

  Everytime a database starts SQL displays the last successful time CHECKDB ran. check the time , it won't be the current time but 7pm the previous night, it is not actually running checkdb.

  this suggests you have the autoclose option set to ON, if this is production turn this option OFF.

  ---------------------------------------------------------------------

• Roger Abram

  Hall of Fame

  Points: 3683

  More actions

  February 12, 2010 at 6:42 am

  #1117992

  That's exactly it... there is a starting up database message and the database is set to close.

  Thank you.

  Roger

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  February 12, 2010 at 7:02 am

  #1118002

  no probs.

  ---------------------------------------------------------------------