restore no error, but can't use database

  • i was trying to restore my backup file to two different databases. i did it in query analyzer, run it at the same time. it finished successfully, but when we were trying to open the database from the enterprise manager, we cannot access it and it has a "loading" caption in both databases.

    and when we tried to access both databases from query analyzer, it prompts, "in the middle of restore".

    how did it happen considering that the restore was successful?

    thanks

  • Just run the RESTORE DATABASE WITH RECOVERY command to get the DB in to a usable state.

    When restoring a database you get three options for the final state of the database.

    Leave database operational. No additional transaction logs can be restored.

    Leave database nonoperational but able to restore additional transaction logs.

    Leave database read-only and able to restore additional transaction logs.

    So may be you've chosen the second option earlier.

    Just try the above solution

    ----------------------------------------------------------------
    **"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply