Solved

Where should we place distributor for Sql 2008 Replication Setup

Posted on 2013-02-07
3
241 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Abstract Express Replacement Software 12 25
How to search for strings inside db views 4 27
VB.net and sql server 4 35
ms sql + get number in list out of total 7 29
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
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.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

773 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