Hi, I have a SQL Server 2000 installed, one day it stopped starting so I decided to reinstall it. I tried to copy my database before reinstalling, but I got some error during copying the mdf file. I tried to copy the file in the safe mode but it didn't work. So then Goggle recommended me to run chkdsk to solve the problem (I guess it was a big mistake). It helped me to copy the mdf file, but when I reattached the mdf file I got an error again, I managed to reattach the file only without the ldf file (it created a new one). Unfortunately it seems the mdf file is corrupted now, I can't even see the tables - (Error 823: I/O error (torn page) detected during read at offset....
I used some repair commands like DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS but in the end I get the same message:
So basically I have a corrupted mdf file, a not broken ldf file (I guess so because I could copy it before chkdsk), and also I have my database which works but it has got only empty tables.
Are there another ways to repair the database?