January 22, 2008 at 12:14 am
I got the Suspected MDF & LDF file from my friend. I am unable attach it. pls let me know how to attach it. and how to recover the data from it. plssssssssssssss
Manjunath G T
January 22, 2008 at 12:20 am
What is the error you are getting?
January 22, 2008 at 6:15 am
error: Could not redo log record id on page.... creating DB is aborted along with some error code..
January 22, 2008 at 9:23 am
What was the reason the database was suspect?
You could try attaching the mdf with no ldf and see if can rebuild it.
January 22, 2008 at 1:49 pm
Generally speaking, you had better restore the database if you have the latest backups.
If your mdf is healthy but ldf is crashed, you can attach the mdf file only and let the system create its new ldf file.
If your mdf is crashed, I am afraid that you may not be able to attach it any more.
January 22, 2008 at 9:14 pm
Even i tried by attaching the MDF only.. then also its working....
January 22, 2008 at 9:15 pm
MDF only crashed... n presently i dont have BACKUP..... Just i need to attach to the server...
January 22, 2008 at 9:25 pm
If you have any old backup you can recover upto that date. Otherwise there is no chance of recovering crashed MDF.
February 4, 2008 at 9:09 am
If your friend did not detach the database before copying the files, you will not be able to attach them.
Steve
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply