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

Merge Replication sync question Expand / Collapse
Author
Message
Posted Wednesday, July 3, 2013 12:28 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, December 24, 2014 11:01 AM
Points: 77, Visits: 311
I've setup Merge Replication on two servers at work, and did it through wizard. I've picked continuous sync, but as far as I can tell, it's syncing only every 60 seconds. Is this as good as it gets, or is there a way to change this?

Post #1470196
Posted Thursday, July 4, 2013 3:33 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, December 4, 2014 10:44 AM
Points: 238, Visits: 1,110
You need to change the polling interval setting in the merge agent profile - the default is 60 secs.

Cheers

Vultar
Post #1470519
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse