Which setting required to use Pull Subscription option for Replication

• neellotus07

  Ten Centuries

  Points: 1245

  More actions

  October 12, 2012 at 11:20 am

  #269502

  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.

  Thanx

  Neel

• irobertson

  Hall of Fame

  Points: 3695

  More actions

  October 23, 2012 at 3:23 am

  #1551799

  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:

  http://www.sqlservercentral.com/Forums/Topic1297654-291-1.aspx#bm1297905

  Regards, Iain