none
SQL Mirroring and NLB

    Question

  • I have an issue with the mirroring of a MS SQL Server 2008 with NLB. I found a post that implies it is not possible to have read/write, what I want to clarify is could we use a second non-NLB network using seperate interfaces on the same servers on which to have the mirroring occur. Something like the basic diagram below with the SQL mirroring occuring on the 172.16.7.x network, and the NLB on the 192.168.7.x network.

    Monday, March 05, 2012 10:03 AM

Answers

  • Hello,

    I'm not sure if this is correct or if you actually have two seperate databases being mirrored to each other.

    Assumptions: DB1 = principal, DB2 = Mirror

    Assuming the above, the only way to have a read only copy of the database on the mirror server is to use database snapshots. Be careful when using snapshots as they are a POINT IN TIME (you'll have to drop/create them every x amount of elapsed unit of time), and could potentially grow very large (it also requires enterprise edition).

    As to the whether the mirroring traffic can be done over the 172.16.7.x network, the answer is yes. The traffic can be segregated when the database mirroring endpoint is created (CREATE ENDPOINT under tcp specific arguments, listener ip address) and when the partner is specified.

    -Sean

    • Proposed as answer by Janos Berke Monday, March 05, 2012 3:22 PM
    • Marked as answer by andronin Tuesday, March 06, 2012 3:44 PM
    Monday, March 05, 2012 3:18 PM
    Answerer