Which setting required to use Pull Subscription option for Replication

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » Which setting required to use Pull...

Which setting required to use Pull Subscription option for Replication

Rate Topic

Display Mode

Topic Options

Author

Message

neellotus07

Posted Friday, October 12, 2012 11:20 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 17, 2013 5:54 AM
Points: 20, Visits: 143

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

Post #1372291

irobertson

Posted Tuesday, October 23, 2012 3:23 AM

SSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 10:26 AM
Points: 210, Visits: 575

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

Post #1375928

« Prev Topic | Next Topic »

Permissions