Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2007
    Posts
    4

    Unanswered: Deleted mdf file

    I am currently trying to recover a data base that i detached. I have search the computer with *.mdf with out results...

    I detached the database from msde 2000 and then installed sql express now when i go to attach the db it is missing, is there away i can recover the db?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    If you have a backup, you can restore from that. Otherwise, you will need the MDF file at a minimum. The .MDF file is usually the datafile that contains all the database metadata (table lists, Allocation pages, etc.). On a side note the extension MDF is not required. Are there other files that might fit the description?

  3. #3
    Join Date
    Sep 2007
    Posts
    4
    i actually don't have a back up... all i know is the file name lis32.mdf. I have searched for that as well, I'm thinking when i installed 2005 it over wrote everything there for msde2000

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    It's dead Jim
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    RESTORE DATABASE MyDatabase
    FROM WormHole = '<insert your path to the space time continium>'
    WITH Recovery

    Have you checked your recycle bin?
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  6. #6
    Join Date
    Sep 2007
    Posts
    4
    I have checked the recycle bin...

  7. #7
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by Brett Kaiser
    It's dead Jim

    What he said

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67782
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  8. #8
    Join Date
    Sep 2007
    Posts
    4
    thanks anyways...

  9. #9
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    This software actually recovers files that have been removed from the database server entirely? It certainly seems to be able to resurrect threads that are two and a half years old. Any thoughts on why zlatan24's post should not be deleted as spam?

Posting Permissions

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