Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    Unanswered: orphaned .mdf file

    I have a .mdf file that I would like to restore. However the log file has been destroyed. Is there any way to restore just an .mdf file?

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    BEWARE. This is not without potential complications, and definitely not for the faint of heart.

    From the GUI, you can't get there from here... From Query Analyzer, you can use sp_attach_single_file_db, and be sure to read the remarks before you start!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts