psingla (6/27/2013)
if i were you then i would have taken the backup first thentried
DBCC CHECKDB (<db>, REPAIR_ALLOW_DATA_LOSS)
Note:note sure this will work on 2000 or not?
Got nothing to do with SQL 2000, those errors are not repairable in any way. CheckDB with a repair option will spend a lot of time trying and will eventually fail with a whole bunch of 'this error can't be repaired' as well as various other messages.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability