sql server replication: Any benefit to using a distributor with only one subscriber for transactional replication? -- sql server replication

Re: Any benefit to using a distributor with only one subscriber for transactional replication?

Ekrem_Önsoy
8/30/2007 12:00:00 AM

Hi Greg,

You have to use a Distributor. It' s located on the Publisher or Subscriber
or a dedicated server (this depends on the workload on Distributor).

There are three essential roles in Transactional Replication

- Publisher simply publish Publications

- Distributor simply distributes Publications to Subscribers

- and Subscribers simply subscribe to Publications and get the Publications
from the Publishers via Distributors. This is the general structure of
Transaction Replication.

You can not omit one of the roles ot of the structure. If workload is a
burden on Distributor then you may consider taking Distributor to a
dedicated Distributor Server otherwise you leave it on Publisher or
Subcriber.

--
Ekrem Önsoy

[quoted text, click to view]

Re: Any benefit to using a distributor with only one subscriber for transactional replication?

Hilary Cotter
8/30/2007 12:00:00 AM

You always need a distributor. If you question is "Any benefit to using a
REMOTE distributor..." the correct answer is that under significant load you
should use a remote distributor. The number of subscribers do not factor
into this choice.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

Re: Any benefit to using a distributor with only one subscriber for transactional replication?

greg
8/31/2007 7:18:49 AM

[quoted text, click to view]

What exactly does the distributor do besides delivery the packets to
the subscribers? Is it the distributor's responsibility to compile
the .bcp files or does the publisher do that?

Re: Any benefit to using a distributor with only one subscriber for transactional replication?

Hilary Cotter
9/2/2007 6:35:28 AM

The distributor
1) contains publication and subscription metadata.
2) contains history about the agents
3) for transactional replication it contains the commands to be replicated
to the subscriber(s).

The publisher generates the bcp files on the publisher.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.