Post reply

Immediate Update Subscriber for Merge Replication

  • February 27, 2003 at 1:08 am

    #80454

    Hi,

    I need guidance about the replication, between the two Servers.

    Both the servers are on the same LAN segment..

    At present merge replication is setup,

    Server1 as Publisher and Server2 as Distributor and Subscriber.

    The subscription is pushed from Server1 to Server 2.

    There is a nearly a minute delay for the replication to get update.

    I need to minimize the dalay between the replicating servers. How I can

    force the server to get replciated in 10-15 seconds. Kindly guide !

    Thanks in Advance

    Edited by - Innovative on 03/06/2003 12:21:53 PM

  • February 27, 2003 at 8:21 am

    #449915

    How do you have the agents set up? Log reader running continuously? Queue reader?

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    Connect with me on LinkedIn

  • February 28, 2003 at 2:02 pm

    #450081

    Yes, the log reader agent is running on continuous, and the data is replication either way after a min or somewhat less.

    I am using SQL server 7 SP4, Sorry I believe the Queue Reader Agent is for snapshot and transactional, by mistake my Q was worded wrongly. Kindly Guide.

    Thanks

    Edited by - Innovative on 03/06/2003 12:44:17 PM

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply