Integrity Check & Index rebuild running at same time

• passivebyz

  SSCommitted

  Points: 1908

  More actions

  August 22, 2010 at 11:14 pm

  #222978

  Hi,

  Could you please tell me what happens when Integrity Check & Index rebuild run at same time for a database?

  Thanks

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  August 23, 2010 at 2:07 am

  #1210283

  i dont think there is any linkage between these two . any specific reason or requirement ? or your are taking about "REPAIR_REBUILD"

  which does minor repairs and also rebuilds indexes without risk of data loss

  OR let me guess "this is interview question" ?

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)