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.
In emergency mode the only repair that's available is repair allow data loss, which will discard damaged data.
At this point I'd say be happy that you got anything back, consider this a harsh lesson and fix up your maintenance (integrity checks and backups) going forward.
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