mlsrinivas (12/22/2010)
I tried with DBCC CHECKDB('TransAidDB', REPAIR_REBUILD), but during this trial I am getting an error that database is to be opened in single user access, which I already did using with both of these options.exec sp_dboption 'TransAidDB','Single User', 'true'
Alter Database TransAidDB SET single_user
I am not able to proceed beyond this step.
Thanks
Srinivas
Not sure if its in single user mode or not but after the allow data loss repair i dont know what you want to accomplish wioth running another checkdb repair_rebuild. Afaik you already passed point no return. either accept the dataloss or go back to a backup