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
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply