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: Today @ 11:27 AM
Points: 75, Visits: 286
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: Today @ 9:21 AM
Points: 234, Visits: 1,085
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