Post reply

Mirror failover

  • March 5, 2013 at 10:03 am

    #290386

    Hi All,

    I have an issue with mirror failover

    1. I configured mirroring on 3 databases. if in 3databses one got failover the other two also need to failover to the mirror server can any one know the TSQL command?

    please post here..

    I have small idea about the query where mirror status is 7 or 8 🙂

  • March 5, 2013 at 11:20 am

    #1593578

    No one knows the answer?

  • March 6, 2013 at 4:38 pm

    #1594210

    Please go through below link

    http://www.mssqltips.com/sqlservertip/1564/database-mirroring-automating-failover-for-multiple-sql-server-databases/

  • March 6, 2013 at 9:06 pm

    #1594254

    Is this manual or automatic failover?

    I dont think if this manual failover then one database failover to mirrored will support for all you need to manually need to failover the rest of DBS.

    Incase if you sre setting up the automatic dailover with withness server then if the withness server does not receive the pingdom from the pricipal serevr then it will initiate failove for all the databases which are participating in mirroring.

    "More Green More Oxygen !! Plant a tree today"

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

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