none
Database marked restoring and is in a state that does not allow recovery to be run

    Question

  • failed over a database and the following error occurred: Database marked restoring and is in a state that does not allow recovery to be run. When I looked at database mirror I saw that the witness and mirror were gone. Anyone experience this problem before?                 

    SQL Server 2008r2/Windows 2008 R2

    Thursday, July 19, 2012 2:57 PM

Answers

  • when you make a Failover in the  mirroring,

    database list in the management studio is not refereshed, please click in refresh button,after making a failover


    Ramesh Babu Vavilla MCTS,MSBI

    • Proposed as answer by PrinceLuciferMVP Friday, July 20, 2012 5:16 AM
    • Marked as answer by Danny Boyx Tuesday, July 24, 2012 5:16 PM
    Thursday, July 19, 2012 4:51 PM