Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Where should we place distributor for Sql 2008 Replication Setup

Posted on 2013-02-07
3
243 Views
Last Modified: 2013-03-25
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
Comment
Question by:shaileshmonani
  • 2
3 Comments
 
LVL 3

Expert Comment

by:AshwaniMunshi
ID: 38863224
0
 

Accepted Solution

by:
shaileshmonani earned 0 total points
ID: 38916772
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
 

Author Closing Comment

by:shaileshmonani
ID: 39017236
We did refer to this article before posting our query here.

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

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question