question

askmlx121 avatar image
askmlx121 asked

Replication info!!

Hi, 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? **Note:** 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
replicationsnapshot
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
0 Likes 0 ·
Cyborg avatar image
Cyborg answered
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][1] [sp_helpsubscriberinfo][2] [sysmergepublications][3] [1]: http://msdn.microsoft.com/en-us/library/ms177504.aspx [2]: http://msdn.microsoft.com/en-us/library/ms190494.aspx [3]: http://msdn.microsoft.com/en-us/library/ms186769.aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

askmlx121 avatar image
askmlx121 answered
ok thank you anuj it help me a lot..........
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.