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.