Skip to Content
0
Former Member
Jul 17, 2015 at 08:42 PM

How to recover corrupted database file?

51 Views

I run MSDE on a Windows XP Server and i found that my database was marked as "suspect" by Enterprise Manager and its icon become gray.

I detach that database and try to re-attach it but there is an error as the following:

Error 3624:

Location : page.cpp:2801

Expression: rowLength >= offset + deleteLenght

SPID : 56

Precess ID:1612

After that, I uninstall the MSDE and re-install new MSDE SP4 and try to re-attach the database file again and there is still an error. I also encounter the same error with MS SQL 2000 Server

Remark: I have all the database file (database.mdf and database.ldf).

Is there anyway i can recover the data from that database?