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.
asked May 24 '12 at 02:04 PM in Default
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.
answered May 24 '12 at 02:07 PM
Grant Fritchey ♦♦