Hi everybody, I have a rather difficult situation that I have to deal with and have hit the limits of my sql/google/bing abilities. I was contacted by one of our offices requesting me to restore a database - fine thinks I - give me the file, and away we go. I was presented with a single MDF file! I have tried the solution that is deemed "normal" in this situation:
This provides the following error:
After reading this message and some further digging I have found out that:
I have also tried creating a dummy DB, stealing the LDF file and starting up the database with the dummy LDF - no dice.
I am now at the point of seeing this as a lost cause - does anyone have anything else to say that could help me along at all? Many thanks in advance for any help offered towards solving this big pile of FAIL.
(comments are locked)
|
If you have open transactions that were not completely committed to the .mdf file... I don't think you've got any hope of restoring this without having a backup available. I wish I could say something else, but there it is. sad times it is then.... I'm gonna give a couple more things a try, then they'll have to try data recovery of the HDD if they really want/need the data. Thanks for the support of my assumption anyway.
May 24, 2012 at 06:39 PM
WilliamD
Sorry. That's not a pretty spot to be in.
May 25, 2012 at 10:28 AM
Grant Fritchey ♦♦
(comments are locked)
|
P.S. I should mention that the office is more than happy to have some data loss - If it is possible to access the data in the MDF in any way, they would be very happy.
P.P.S - I hate writing this post - it is a cringe-inducing situation, especially as I had warned them of the importance of maintaining restorable backups when the system was commissioned.
Have you read this: ? http://sqlskills.com/blogs/paul/post/TechEd-Demo-Creating-detaching-re-attaching-and-fixing-a-suspect-database.aspx
I would also try and make sure that I was restoring onto the same version/edition/SP if poss
Thanks Kev, I'll give that a try - not hopeful though and tend to agree with Grant - they are without data.
You have prob been here, but did you try http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/MSSQLServer/recover-a-database-without-the-ldf-file. Worked for me in the past