Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Friday, October 12, 2012 11:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 31, 2013 2:00 AM
Points: 21, Visits: 150
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
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: Tuesday, April 22, 2014 1:02 AM
Points: 227, Visits: 666
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 »

Add to briefcase

Permissions Expand / Collapse