what is repair_rebuild

• abishekshroff

  SSCrazy

  Points: 2040

  More actions

  February 19, 2010 at 3:13 am

  #216849

  what is the difference between repair_rebuild and dropping and recreating an index

  DBCC CHECKDB reported repair_rebuild .

  i tried to drop and recreate index and no good

• Paul Randal

  One Orange Chip

  Points: 29544

  More actions

  February 19, 2010 at 5:15 pm

  #1122211

  Repair_rebuild fixes problems with non-clustered indexes, including forcing index rebuilds to rescan the base table.

  What are the corruptions? (i.e. output from DBCC CHECKDB (yourdb) WITH NO_INFOMSGS, ALL_ERRORMSGS

  Thanks

  Paul Randal
  CEO, SQLskills.com: Check out SQLskills online training!
  Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
  SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
  Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005