locked
DB Load Balancing with mirroring ? RRS feed

  • Question

  • Hi guys, can I know whether 2 servers (load balancing) able to set up the mirroring on another server? From what I know, mirroring only can set 1 IP address for principal. I just want to double confirm on it. Thanks for any assistance here.

     

    Best Regards,

          Hans

    Friday, April 27, 2007 3:22 AM

All replies

  • Hi Hans,

     

    Is your question whether you can 2 principal servers sharing the same mirror to host mirror databases.

     

    If yes, then the answer is yes as long as the database names are different. Also, you will need to be aware that when you failover both principals on to one mirror server, the performance will not be the same.

     

    Jag

    • Proposed as answer by XtendedLearner Wednesday, April 6, 2016 4:21 PM
    Friday, April 27, 2007 5:19 PM