[arenawarper]

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?

[Advertisements]

1. If the database is open, close it.
2. On the Tools menu, point to Database Utilities, and then click Compact and Repair Database.
3. In the Database to Compact From dialog box, select the file that you want to compact, and then click Compact.

[THOMAS123456]

1. If the database is open, close it.
2. On the Tools menu, point to Database Utilities, and then click Compact and Repair Database.
3. In the Database to Compact From dialog box, select the file that you want to compact, and then click Compact.