Post reply

2005 Mirror failover

  • September 8, 2010 at 12:33 pm

    #237977

    I have 2 servers I am testing this on. I have no witness and what I wanted to do is to say if the main Principal goes down hard can I bring up the mirror so I can access it?

    So far when I shutdown the main server "Principal" the server that it is mirroring too goes from (Mirror, Synchronized / Restoring) to (Mirror, Disconnected / In Recovery). What can I do to make the Disconnected database become on-line?

    Thanks

    Ryan

  • September 9, 2010 at 8:41 am

    #1218669

    If you post this question in SQL 2005 Administration forum, you will get better response. I am no Mirror expert.

    -Roy

  • September 10, 2010 at 1:56 am

    #1219018

    Hi Ryan,

    If the principal is unavailable and you want to force a mirror to become the principal and to start serving the database to users then on the mirror server issue the command:-

    ALTER DATABASE mydatabase

    SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

    However you should note that if you are using asynchronous mirroring and you issue this command, then there is the potential to lose data which has been committed on the principal but not yet on the mirror.

    Hope that helps.

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

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