on 07-17-2015 9:42 PM
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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.