Where should we place distributor for Sql 2008 Replication Setup
Posted on 2013-02-07
We have SQL Server 2008 Standard edition and are setting up Replication for the first time. Scenario is a Head Office server and 18 Regional Servers. On a single server at HO all the 18 RO server database will get replicated individually.
RO server has been setup as Publishers and HO server is a single subscriber to all the 18.
Where should the distributor be placed for such a scenario, presently we have Distributor at RO Servers 18 locations each. Will there be any advantage to have Distributor at Subscriber (HO) server.
We are also looking at error / log reporting as an when replication for each of the RO server is executed.