Should I never put a transactional replication distributor on a subscriber server?

Posted by Stuart Branham on Server Fault See other posts from Server Fault or by Stuart Branham
Published on 2012-09-14T20:56:33Z Indexed on 2012/09/14 21:39 UTC
Read the original article Hit count: 143

Filed under:
|

What factors into choosing a distribution server for transactional replication? In our topology, we've always had the distributor reside on the publishing server. We rarely generate snapshots and performance is good enough, so this is okay for us today. One of our instances is moving to a cluster, so we need to move the distributor off for resilience/symmetry.

Right now our two choices are to use a server physically close to the publishers, or our single subscription server. Our publisher is in our main office, and our subscriber is in a colocation facility off-site which our ISP runs. We have a pretty good line to it. The reason we're even considering the latter is to save work and licensing costs.

© Server Fault or respective owner

Related posts about sql-server

Related posts about replication