Asymetric Database Mirrors

  • 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

  • It should work as long as the databases have distinct names. Bear in mind that the mirror server is going to do more work now (especially if any databases fail over), you should confirm that it has sufficient resources to do what you need it to do.

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

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