Monday, March 19, 2012

How to recover corrupted MDF file?

Hi, all,
I have a big problem.
I cannot attach my DB to the server again after detached it.
Error is "...file you've specified is not a valid data file ...".
After checked the system event log, I found "...torn page found at..."
errors before it was detached.
Is there any to recover the database file or recover the data from it?
Thanks a lot.
--
Regards
Wicky HuI think that the only people who can help you now would be
microsoft.
There are some ways of repairing the file but it assumes
that the database is running and has not been detached.
The only execption to the rule is if its the master
database, then there is a tool to do it.
The best cause would be to restore from the last backup.
Peter
"Action speaks louder than words but not nearly as often"
Mark Twain
>--Original Message--
>Hi, all,
>I have a big problem.
>I cannot attach my DB to the server again after detached
it.
>Error is "...file you've specified is not a valid data
file ...".
>After checked the system event log, I found "...torn page
found at..."
>errors before it was detached.
>Is there any to recover the database file or recover the
data from it?
>Thanks a lot.
>--
>Regards
>Wicky Hu
>
>.
>

No comments:

Post a Comment