Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Which setting required to use Pull Subscription option for Replication Expand / Collapse
Posted Friday, October 12, 2012 11:20 AM


Group: General Forum Members
Last Login: Monday, September 5, 2016 11:04 AM
Points: 24, Visits: 157
Hi All,

I want to implement Replication on my SQL server.And i have two different server like server1 and server2 with SQL Server 2005 installed including All Agent services.

Firstly i configured Distributor on both server (using SQL Server M.Studio).
Then i configured & Publish DB on Server1 with Snapshot publication type (using SQL Server M.Studio).
Then i configured Subscription DB on Server2 (using SQL Server M.Studio).

Now i want that Subscriptions DB use Pull Subscription option to update data from publication DB to subscriptions.
So at the time of Subscriptions DB configuration i select "Run each agent at its Subscriber (pull subscriptions)" to reduce workload of Server1.

But Subscriptions DB not updating any Data from publish DB.

Please tell me where i am doing wrong and please tell me if any additional configuration required.

I will be very thankful to you.


Post #1372291
Posted Tuesday, October 23, 2012 3:23 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, September 3, 2015 3:33 AM
Points: 227, Visits: 675
Hi Neel,

You might have the same problem that I had with creating a new subscription. Have a look at this thread and see if it helps:

Regards, Iain
Post #1375928
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse