mlsrinivas (12/22/2010)
I tried various tools and options but of no use. I am giving below the process I followed which had lead close to recovery (I could see that data but huge number of records missing). I am not sure what I did wrong in this process, please help me to correct this.
You ran CheckDB with REPAIR_ALLOW_DATA_LOSS and you're surprised that there's data missing afterwards?
If the repair deallocated data and you have no good backup, that data is gone and not recoverable. It was likely gone and unrecoverable before you ran the repair because of the corruption.
The way you recover from severe corruption without data loss is by restoring a backup. No backup - not many options left.
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