December 3, 2007 at 12:50 pm
I have recently joined one of the company they have 20-25 servers.
They have Transaction replication
They have seperate Publisher, Distributor and Subscriber server.
How do I know which one is Publisher or Distributor or Subscriber?
Is there any way to find, if I am on publisher or distributor and how should I know which publisher a distrubutor is using and vise-versa
Nita
December 3, 2007 at 12:59 pm
If you go to Enterprise Manager, you can check under the replication tab to see your publications. These are publishers. You can also check subscriptions. The publication properties will tell you where the distributor is.
Note that a particular server can be all three or any combination of them.
December 3, 2007 at 1:00 pm
In ent mgr you can expand the Replication folder on each server.
You will see publications only on a publisher. Expand publication to see each server subscribing to pub.
Right click on 'Replication' folder at pub - select 'Configure PUblishing, Subscribers, and Distribution...' - on 'Distributor' tab you will see distributor svr for publisher.
ChrisB MCDBA
MSSQLConsulting.com
Chris Becker bcsdata.net
December 3, 2007 at 1:20 pm
Is there any system table which keep all this information for Publisher and Distributor
Like who is the distributor and there subscriber and vise-versa?
Nita
December 3, 2007 at 1:34 pm
[publisher].[userdb].syspublications
[publisher].[userdb].sysarticles
[publisher].[master].sysservers where srvname = 'repl_distributor'
[distributor].distribution.MSsubscriptions
ChrisB
Chris Becker bcsdata.net
December 3, 2007 at 1:37 pm
I am almost there but how do I know which is which etc?
Anyhow thanks Chris
Nita
December 3, 2007 at 4:52 pm
The srvname should tell you which server. The table tells you if it's publishing or subscribing. Not sure about distributor.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply