Lost the MDF, have the LDF
-
Hi all. I had a partition take a complete dump on me and lost the .MDF of one of my databases. I have the log files on a separate drive array, so I still have the .LDF of that database. Is there a way to restore my database from the log? And to answer the next question before it gets asked: no, my NetAdmin didn't have the tape running on that server because he "didn't know" I meant to have that server backed up when I included it in the list of servers to be backed up. Also, ChkDsk /r was not able to recover that particular file (though I did get all the other data files back).
-
I dont think so. The data in the ldf doesn't represent all the data in the mdf, much less the structures. I think your only hope is to send the drive(s) to a recovery service.
Andy
-
Observed a similar loss of a database a few months ago and as suggested a recovery service was able to recovery. Did observe loss of humor from management aswell.
-
Please do not cross post. See/leave responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=12703&FORUM_ID=9&CAT_ID=1&Topic_Title=Lost+the+MDF%2C+have+the+LDF&Forum_Title=General
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply