hello: i was given a corrupted mdf file, the server the database (sql 2000) crashed and the only file recovered was this .mdf file. I have tried as many of the options that i can find, and still cannot get this database recovered. downloaded several of the programs that claim to be able to recover mdf files and none work.. This latest gives me the following errorQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0xaaaaaaaa; actual signature: 0xd8b4c0f2). It occurred during a read of page (0:0) in database ID 0 at offset 0000000000000000 in file ‘C:\DBIO\testy.mdf’. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
I created a new database (sql 2008 r2) since I do not have sql 2000 anywhere. renamed the mdf file and then renamed the corrupted one to the new name and restarted. This then brings up the db in recovery_pending mode and I cannot get it out of that mode. Tried setting it to emergency mode, no luck. Is there anyway for me to recover this db?
No there were no backups of this database at all, and yes, i completely agree that a backup strategy is needed, but i’m just the lucky recipient of the issue
I am very sorry to hear of the troubles you are having. This does sound like a difficult situation, and I am honestly not sure how to resolve this. As you are using MSSQL, our ability to help with this is limited. I’ve done a little digging, and it appears that setting the database to EMERGENCY mode, then repairing it, has worked for some people in the past. I would strongly recommend backing up the database, even in its current state, before trying anything.