Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

How to recover corrupted database file

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 1 posts

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?

  • 0





  • Member
  • PipPip
  • 10 posts
  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.

  • 0

Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP