Post reply

Database cannot be opened. It is in middle of restore.

  • July 14, 2009 at 11:46 pm

    #155965

    Hi all,

    i was restoring the sql server database. It stopped. and now while accessing, it gives the Erro message:

    Msg 927, Level 14, State 2 , Line 1

    Database 'master' cannot be opened. It is in middle of restore.

    I want to take it to previous state that is before restoring.

    Please let me know if there is any way to do this.

    Thanks,

    Amit Khanna

  • July 14, 2009 at 11:59 pm

    #1024819

    You can try again restore.

    Be careful if it's production.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • July 15, 2009 at 3:03 am

    #1024884

    Hi

    All,

    Can you tell me which database are you trying to restore master or User database.

    Thanks nad regards

    Ashwin v p

    Ashwin VP
    CSC India ...

  • July 15, 2009 at 3:54 am

    #1024903

    http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/8dd1b91d-3e14-4486-abe6-e3a550bfe457

    Thanks

  • July 15, 2009 at 6:42 am

    #1024974

    It is a user database.

  • July 15, 2009 at 8:10 am

    #1025065

    Hi Amit,

    Use this command. It will bring back from restoring state to normal. You can proceed further on how you want. Check this and let me know.

    RESTORE DATABASE dbname WITH RECOVERY;

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • July 15, 2009 at 8:31 am

    #1025090

    Amit Khanna (7/15/2009)

    It is a user database.

    :blink: Are you sure? Look at your original post...

    Msg 927, Level 14, State 2 , Line 1

    Database 'master' cannot be opened. It is in middle of restore.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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

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