locked
Asymetric Database Mirrors RRS feed

  • Question

  •  

    We have an architecture of two production SQL 2005 Servers and two mirrors. The traffic has spiked on the two front servers, so the decision was made to add a new server to the top tier. Why the powers that be won't pop for the additional mirror server is another story. The question at hand is whether or not it is possible to mirror the 3 tier I servers to the 2 tier II servers?

    Brandon Forest
    SQL DBA
    bforest@directapps.com
    Friday, February 15, 2008 10:19 PM

Answers

  • Welcome to MSDN Forums Smile

    Your situation is as follows, pls correct me if i misunderstood.

    • Two production (A and B) Sql 2005 servers ---> Tier I
    • Two other Sql 2005 servers (C and D) ---> Tier II
    • Now you are adding one more Sqk 2005 server (E) to Tier I and want to configure database mirroring from the three Tier I servers to Two Tier II servers.

    Yes you can configure as follows,

    • A (principal) to C (mirror)
    • B (principal) to D (mirror)
    • E (principal) to C (mirror) or D (mirror) both are possible

    You need to ensure that the mirror server C/D has necessary hardware requirment to store the data as it will be the mirror server for 2 servers. Just additional information, we have mirroring configured in our work place as follows,

    A (principal) ---> B (mirror)

    C (principal) ---> B (mirror)

     

    - Deepak

    Saturday, February 16, 2008 1:22 AM

All replies

  • Welcome to MSDN Forums Smile

    Your situation is as follows, pls correct me if i misunderstood.

    • Two production (A and B) Sql 2005 servers ---> Tier I
    • Two other Sql 2005 servers (C and D) ---> Tier II
    • Now you are adding one more Sqk 2005 server (E) to Tier I and want to configure database mirroring from the three Tier I servers to Two Tier II servers.

    Yes you can configure as follows,

    • A (principal) to C (mirror)
    • B (principal) to D (mirror)
    • E (principal) to C (mirror) or D (mirror) both are possible

    You need to ensure that the mirror server C/D has necessary hardware requirment to store the data as it will be the mirror server for 2 servers. Just additional information, we have mirroring configured in our work place as follows,

    A (principal) ---> B (mirror)

    C (principal) ---> B (mirror)

     

    - Deepak

    Saturday, February 16, 2008 1:22 AM
  • When you configure witness server for db mirroring then the data transfer will be symmetric and the operating mode will be considered as High Availability
    Saturday, February 16, 2008 2:48 AM
  • Yes it is possible

    Monday, February 18, 2008 3:14 PM