[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Where should we place distributor for Sql 2008 Replication Setup

Posted on 2013-02-07
3
Medium Priority
?
280 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
[X]
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
  • 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

649 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