• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 284
  • Last Modified:

Where should we place distributor for Sql 2008 Replication Setup

Hi,

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.

Kindly advise.
0
shaileshmonani
Asked:
shaileshmonani
  • 2
1 Solution
 
AshwaniMunshiCommented:
0
 
shaileshmonaniAuthor Commented:
Hi,

We did refer to this article before posting our query here.

No other comments have been added to this query also.

In this situation we wish to suspend this query. What action will be required for this?
0
 
shaileshmonaniAuthor Commented:
We did refer to this article before posting our query here.

No other comments have been added to this query also.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now