How to recover corrupted database file

Discussion in 'Computing and Networks' started by oliwialosha, Oct 4, 2015.

  1. oliwialosha

    Thread Starter New Member

    Oct 4, 2015
    1
    0
    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?
     
  2. AdamHenriksen

    New Member

    Aug 4, 2016
    1
    0
    Corruption in SQL server database can happen due to any uncertain like virus attack, power failure, hardware issue, OS malfunction, and sudden system shutdown, so on. When a SQL server data file (.mdf) is corrupt then DBAs can try several methods to repair and recover data from it.

    • Run DBCC CHECKDB: It checks & reports all the error message in error log, if there is any problem with the database. Try to analyze & understand the error message logged in the error log. Re-run DBCC CHECKDB with the recommended minimum repair option to repair the file.
     
Loading...