Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    10

    Unanswered: URGENT!!! Detached database

    HI GUYS,

    I AM REALLY IN NEED of some urgent help. I just detached my database without backing it up

    Does that mean I lost it for ever??????? Please somebody say no!!!

    How can i recover from my fatal mistake

    somebody HELP

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    If you detached the database, then you can attach the database. Through query analyzer, you can use sp_attach_db. In enterprise manager, right click "databases" -> all tasks -> attach database.

  3. #3
    Join Date
    Nov 2003
    Posts
    10
    Originally posted by rnealejr
    If you detached the database, then you can attach the database. Through query analyzer, you can use sp_attach_db. In enterprise manager, right click "databases" -> all tasks -> attach database.
    It asks me for the file. I don't know where is my database.

    I mean when I created the database, I don't know where does it save those files. Now, when I want to attach the database, it is asking me the address to save the database from. And I have no idea where should i look for.

    I will greatly appreciate any help

  4. #4
    Join Date
    Nov 2003
    Posts
    10
    Thanks a lot for your help

    I figured out the last question

    I attached my database back.

    thnx again

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    Happy to help.

Posting Permissions

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