Chandu (7/27/2009)
Hi Vishal,I am surprised that without root cause analysis you used dbcc with allow data loss and that too in production. Can you post the error messages which you got before applying dbcc with allow data loss.
Because conistency was since two weeks and we had no times to do an RCA first and then repair the DB so I am doing RCA now.
the Smaple errors were like this:
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 206623779. The text, ntext, or image node at page (1:4846), slot 7, text ID 18859360256 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 206623779. The text, ntext, or image node at page (1:4846), slot 9, text ID 18859425792 is not referenced.