pankaj.baluni (1/5/2010)
Do you have old .mdf and .ldf files(not of the day when DB got corrupted)? you might have taken file backup on some storage.... so get it and save it some where on this server.If yes, just delete the current .mdf and .ldf as the DB is any which ways useless now.
attach the old .mdf and .ldf files and see if that works.... (as the chances are very less).... if not then I'm sorry to say that the DB is gone now.....
I wouldn't be so quick to delete the .mdf file, there are different types of corruption and it can be possbile to recover the data and the amount of data lost depends on the corruption.
for example a corrupt NC index would not be as big issues as a corrupt Clustered index.