Solved How can i recover corrupted database file( .mdf .ldf).

Microsoft Sql server 2008 r2 standard (l...
November 28, 2014 at 07:15:15
Specs: Windows 7

I run MSDE on a Windows XP Server and 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.
Is there anyway i can recover the data from that database?
Would appreciate your help

See More: How can i recover corrupted database file( .mdf .ldf).

Report •

December 2, 2014 at 06:30:33
✔ Best Answer
Hi! Try to fix this problem:

• Click the Windows \"Start\" button and select \"All Programs.\" Click your \"SQL Server\" program group and click the \"SQL Server Management Studio\" shortcut. This opens the Management Studio console application.
• Click the SQL Server name on the left side of your console. In the main toolbar, click \"New Query.\" This opens a query window where you execute the \"sp_attach_db\" stored procedure.
• Type the following command into your query console:
sp_attach_db 'Database_Name','c:\backupDB.mdf','C:\backupLogs.ldf'
• The first parameter is the \"Database_Name.\" This is the name of the database that registers with SQL Server. This can be the original name of the backed up database, or you can give it a new name. The second parameter is the location and file name for the MDF file. The third is the location for the LDF file. You can restore from the local hard drive, an external drive or a shared network location.
• Press the \"F5\" key. This executes the SQL statement and restores the database along with the log file.

or use:

Report •

June 22, 2015 at 22:43:30
Use SQL Database Recovery tool which help you to recover MDF and NDF file, including all components like tables, views, function, stored procedure, rules, etc. The software will help you to recover deleted tables of the SQL Database tables and support all SQL Server editions.
For more details: -

message edited by johnwalker10

Report •

August 10, 2015 at 02:26:34
Get more effective perfect software, you can use Kernel for SQL Database Recovery Tool. This software recovery of all the elements including Tables, Functions, Stored Procedure, Triggers and Associated Primary Key, Data Types, Unique Keys, Views, Rules and etc. To know more detail click here -

message edited by johnphlip

Report •

Related Solutions

January 28, 2016 at 01:28:02
This article will be discussing about the types of SQL database files and their corruption issues. The later part consists of the ways on how to repair the corrupted MDF & LDF Files and recover data from the corrupted state of files.

Report •

March 14, 2016 at 04:32:18
‘.mdf ‘ or 'LDF' file gets corrupted due to any internal or external error and if these file gets damage then it can corrupt the entire database or make it inaccessible. This file contains the structure of the database and all operations are executed on to a single .mdf file so that it can be easily got corrupted.

You can recover and restore corrupted .dbf file by using Database Repair Tool, this tool can easily repair and restore your corrupt .mdf file.

For more you can visit:

Report •

Ask Question