Replication info!!


We are using Snapshot replication.

I want to know the answer of 3 questions from below.

1)which Replication Topologies are

our server using? like Central publisher,central subscriber,Central publisher with

remote distributor ...etc

2)who is publisher? who is subscriber? who is distributor?

3)which is publication? which is articles? which subscription?

Is any query to find or any method to find out?


I did nt want explanation of publisher,subscriber,distributor etc. I want to know who

is publisher

or subscriber or distributor in current using sql server

more ▼

asked Jan 22, 2013 at 12:23 PM in Default

avatar image

2.5k 72 76 83

At the risk of going on a tangent, there is a great article about replication just published at http://www.mssqltips.com/sqlservertip/2853/troubleshooting-sql-server-replication/ It is mostly focused on troubleshooting, but has some nice descriptions of replication in an easy to understand fashion as well as links to other articles with in depth descriptions.

Jan 22, 2013 at 09:15 PM TimothyAWiseman
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

A Central Publisher is where your publisher and distributor resides in same server and you have subscriber in another server. If your distributor is not in the publisher server then your in Central Publisher with remote distributor. A Central Subscriber is where you have multiple publications replicate data to a single article this is done using filter option in article property. e.g say you want to replicate data from different sales region (based on SalesID) to a central subscriber table (with all sales region data) you should consider Central Subscriber method.

There are various system tables and stored procedures to get the details about publisher, subscriber and distributor info.

sp_helpdistributor sp_helpsubscriberinfo sysmergepublications

more ▼

answered Jan 22, 2013 at 12:58 PM

avatar image

10.8k 37 57 51

(comments are locked)
10|1200 characters needed characters left

ok thank you anuj it help me a lot..........

more ▼

answered Jan 23, 2013 at 06:24 AM

avatar image

2.5k 72 76 83

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 22, 2013 at 12:23 PM

Seen: 599 times

Last Updated: Jan 23, 2013 at 06:24 AM

Copyright 2018 Redgate Software. Privacy Policy