Is the system that pulls the distributor?

Pull subscriptions means that the distribution agent
works on the subscriber. It reads commands from the
distribution database. The distribution database can be
located on the publisher or a separate server. The
distribution database is written to by the log reader and
read from by the distribution agents, so a lot of work is
done on it. Most people offload work by using pull
subscriptions first and if this is not enough, then move
the distribution database to be set up on another server.
This article may help a bit:
http://www.microsoft.com/technet/pro.../sql/2000/main
tain/tranrepl.mspx
rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
On Fri, 12 Nov 2004 02:15:36 -0800, "Paul Ibison"
<Paul.Ibison@.Pygmalion.Com> wrote:
>Pull subscriptions means that the distribution agent
>works on the subscriber. It reads commands from the
>distribution database. The distribution database can be
>located on the publisher or a separate server. The
>distribution database is written to by the log reader and
>read from by the distribution agents, so a lot of work is
>done on it. Most people offload work by using pull
>subscriptions first and if this is not enough, then move
>the distribution database to be set up on another server.
>This article may help a bit:
>http://www.microsoft.com/technet/pro.../tranrepl.mspx
Also at:
http://www.msdn.microsoft.com/librar...asp?frame=true
Yes, I think that after I posted the question, I read in this article
that the distributor stays with the publisher even for pull
subscriptions, moving the distributor is a separate issue.
Well, this is all a bit new to me, I'll just take this one step at a
time, leave the distributor in place until everything else is working,
then worry about it.
Thanks for your help.
Josh