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.
2 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.
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!

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

Related Discussions

Related Forums