Question

database file( .mdf .ldf)

By PalBodnar ·
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.
4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

.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

Collapse -

mdf .ldf

by PalBodnar In reply to .mdf .ldf

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

Collapse -

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 - filerecoverytips.com/restore-sql-database-objects/

Collapse -

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

Back to Tips and Tricks Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums