SQL transactional pull replication

Ben Thul

2011-07-31 13:56:48 UTC

the difference between a push and a pull subscription is where the
distribution agent job runs. For a push subscription, the job will
run at the distributor and push commands from the distributor to the
subscriber. For a pull subscription, the job will run at the
subscriber and pull commands from the distributor to the subscriber.
Neither configuration changes where the distributor actually lives.
That is configured by you when you set up the publication server. You
can find out where your distributor is set up by running
sp_helpdistributor at the publisher. Hope this helps.
--
Ben

Post by amita pallod
I am setting transactional replication (pull) from 2005 to 2008
servers.
I created subscriptions on SQL 2008 server to pull data from 2005
publication. But I get this error-
The process could not connect to Distributor. It says my distributor
is on publication.
I am not sure how that happened? I thought pull subscription will
always setup distributor at subscriber server not at publisher.
Can someone please help me?