Question

  • Creator
    Topic
  • #2342442

    database file( .mdf .ldf)

    Locked

    by palbodnar ·

    Tags: 

    I run SQL 2008 on a Windows 7 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 SQL and re-install new SQL and try to re-attach the database file again and there is still an error.
    Remark: I have all the database file (database.mdf and database.ldf).

    Is there anyway i can recover the data from that database?

    PS. I already notice that there’s a MSSQLRecovery program.
    PS. I have the backup data but it’s too old.

All Answers

  • Author
    Replies
    • #2442705

      .mdf .ldf

      by alfbirkeland ·

      In reply to database file( .mdf .ldf)

      Have u tried out the old way of creating empty database with same name.
      Stop sql server
      Paste database at the same location …
      And restart the server ….
      If that doesn’t help from personal experience I can recommend MDF Repair Kit. how to repair .mdf file you can know from link. http://www.mdf.repair/
      Does it helping u out …..
      Let me know what is the result

      • #2442704

        mdf .ldf

        by palbodnar ·

        In reply to .mdf .ldf

        Thank you very much for the help! you helped me a lot!

    • #2448187

      How to repair SQL database?

      by natty_sem ·

      In reply to database file( .mdf .ldf)

      There’s a built-in tool in MS SQL Server, called Microsoft SQL Server Management Studio. It comes with MS SQL Server 2005 and later versions. By using this tool, you can run a couple of database console commands: DBCC CHECKDB and DBCC DBREPAIR. This will help you repair SQL database which is tagged as suspect.

      Refer to this article for complete information – [url=http://filerecoverytips.com/restore-sql-database-objects/]filerecoverytips.com/restore-sql-database-objects/[/url]

    • #2447714

      Complete Solution

      by alice samanta ·

      In reply to database file( .mdf .ldf)

      Hi

      Usually issues like error 3462, 5171 all are same in SQL Server database. As they occur due to problem in hardware and software. Or, there is incompatibility in between hardware and software.

      Might be there is virus and malware attack.

      No nee to worry here is the all in one solution to do it.

      For more info: https://www.quora.com/How-do-I-troubleshoot-an-MS-SQL-server-error-5171

Viewing 2 reply threads