Post reply

Management Studio says my database is (Restoring...)

  • February 24, 2009 at 10:21 am

    #128020

    I restored a database onto my server and it completed successfully, However, when I refreshed my database I showed the database available and also another entry with the same database name with (Restoring...) next to it.

    I was able to take the database offline and detach it (I didn't need it there, was just to test something), but the (Restoring...) one wont go away.

    Can anyone provide any insight?

    I've attached a screenshot of the offending database.

    Thanks

    --------------------------

    I long for a job where my databases dont have any pesky users accessing them 🙂

  • February 24, 2009 at 12:13 pm

    #949584

    Just a question - did you use the NORECOVERY option when you restored the database?

    Thanks,

    Lori

  • February 24, 2009 at 12:22 pm

    #949586

    It looks to me that you restored the db under a new name and used NoRecovery (or selected the option in SSMS.

    How did you do the restore?

  • February 24, 2009 at 12:33 pm

    #949591

    i did restore as a different name, i did the restore by right clicking databases and picking restore.. i dont recall if i had norecovery on or not.. i really only restored it so i could get one little thing done.. then i was done i wanted to get rid of it..

    is there a way i can remove this entry?

    --------------------------

    I long for a job where my databases dont have any pesky users accessing them 🙂

  • February 24, 2009 at 12:38 pm

    #949594

    Have you tried running:

    RESTORE [DATABASE]

    WITH RECOVERY

    Thanks,

    Lori

  • February 24, 2009 at 12:45 pm

    #949598

    Thanks Lori, that did it..

    Still odd though.. at one point i had DBWMS002_old up and running right next to DBWMS002_old (Restoring...)

    But, I wont worry about it anymore..

    Thanks everyone for your ideas

    --------------------------

    I long for a job where my databases dont have any pesky users accessing them 🙂

Viewing 6 posts - 1 through 5 (of 5 total)

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