I'm setting up load balancing, transactional replication and mirroring. However, what I actually thought might work from the beginning, making the system redudant doesn't actually work because a Publisher can't have multiple distributors.


This is what was intended to do from the beginning:

enter image description here


This is what we have to go with and my concern is that the weak spot is if remote Distributor server goes down it will stop syncing out the latest data. How can I make the distributor redundant?

enter image description here


There is no support for Distribution failover in MSSQL replication.

One solution to this limitation is to use Windows clustering on the Distribution database. See more about clustering here: http://sqlmag.com/sql-server-2008/planning-and-implementing-sql-server-cluster http://sqlmag.com/sql-server-2008/set-sql-server-2008-cluster http://sqlmag.com/sql-server-2008/upgrading-sql-server-2005-cluster-sql-server-2008

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.