cancel
Showing results for 
Search instead for 
Did you mean: 

How to recover corrupted database file?

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Try to attach bypassing the log file by using sp_attach_single_file_db. I'm not sure if this will actually work or if the db will come up as clean if it does work.  

luisdarui
Active Contributor
0 Kudos

Hi Margos,

For curiosity, what SAP system is running on this MSDE database? I can't find any SAP NetWeaver based system that supports it.

Regards,

Luis Darui