locked
database not failover RRS feed

  • Question

  • I have a database mirroring environment.

    When the principle database down, it cannot failover to mirroring database.

    Why does this happen? How to fix that?

    • Moved by Papy Normand Thursday, September 13, 2012 10:23 PM Related to database mirroring and failover (From:SQL Server Data Access)
    Thursday, September 13, 2012 2:02 PM

Answers

  • When you are not using witness server & your principle database goes down.

    You need to manually failover to secondary  databse with force command.

    ALTER DATABASE <database_name> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

    As Andrew mention, refer the link for more details.


    Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!

    • Proposed as answer by Edwin M Sarmiento Thursday, September 13, 2012 11:09 PM
    • Marked as answer by torres0319 Monday, September 17, 2012 11:25 AM
    Thursday, September 13, 2012 7:28 PM

All replies

  • Thursday, September 13, 2012 2:04 PM
  • When you are not using witness server & your principle database goes down.

    You need to manually failover to secondary  databse with force command.

    ALTER DATABASE <database_name> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

    As Andrew mention, refer the link for more details.


    Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!

    • Proposed as answer by Edwin M Sarmiento Thursday, September 13, 2012 11:09 PM
    • Marked as answer by torres0319 Monday, September 17, 2012 11:25 AM
    Thursday, September 13, 2012 7:28 PM
  • Hello torres0319,

    Your thread is not relatd to the SQL Server Data Access, but there is a "better" forum

    http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/threads

    It is why i will move your thread towards this forum .Only a moderator can do a move ( no thread to recreate, no lost posts, especially when they are useful ). As it is later than midnight, i will stop for today  and it is why i am doing the move without waiting for your agreement for this move.

    Have a nice day


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

    Thursday, September 13, 2012 10:22 PM
  • Hello,

    Move done.I hope you will find a quick and full answer in this forum.

    Have a nice day


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

    Thursday, September 13, 2012 10:25 PM
  • when the principle server is down

    logon to the mirrored server and run this command

    alter database dbname set partner off

    go

    restore database dbname with recovery


    Ramesh Babu Vavilla MCTS,MSBI

    Friday, September 14, 2012 10:22 PM