DBCC CHECK DB outcome - DB Refresh

• ramana3327

  SSCoach

  Points: 19722

  More actions

  October 22, 2015 at 2:30 pm

  #321714

  Hi,

  I created sql job using maintenance plan to run DBCC Checkdb for all databases. But I didn't choose the option Ignore databases where the state is not online. If any db is restoring the same time as DBCC Check db job running, is check db job fails?

• Ant-Green

  SSC Guru

  Points: 113563

  More actions

  October 23, 2015 at 2:17 am

  #1835077

  Try it out see what happens. Restore a DB with NORECOVERY to leave it in a restoring state, then run your maintenance plan.