SQL Server Performance Forum – Threads Archive
SQL 2005 Suspect DatabaseIn SQL 2005,
Using DBCC Checkdb(‘dbname’,repair_allow_data_loss) is the only) is the only way to repair this database ? Because I know which index is corrupted and i just want to drop it. Can anyone help me… AB
Post the details of corruption… If you know the index is the problem you can drop and recreate it or run DBCC DBREINDEX or ALTER INDEX WITH REBUILD option…
You can also use DBCC CHECKTABLE too…
confirm that its an index and just drop it.. you will be all set to go.. run a dbcc checkdb once again after dropping index from database. Deepak Kumar
MVP, MCDBA – SQL Server
[email protected] Disclaimer: This post is provided as is with no rights & warranty for accuracy, for the sake of knowledge sharing only.