Groups | Blog | Home
all groups > sql server replication > january 2006 >

sql server replication : Synch not finishing


David
1/27/2006 12:23:22 PM
We have a couple of laptop subscribers that are timing out or they are
stopping a synch before it finishes due to a long synch time. Is this
damaging anything? We seem to be losing records or getting conflicts
because of this. Thanks.
p.s. Merge replication SQL 2k and MSDE.

David

Hilary Cotter
1/27/2006 3:11:22 PM
Can you enable logging to determine exactly why they are timing out?

http://support.microsoft.com/kb/312292/en-us

There are two possible issues - you have too many merge agents running
concurrently and need to limit the number of them (make sure you set the
StartQueueTimeout setting to something larger 120 s or so), or the amount of
data you need to merge or the merge process is lengthy - set QueryTimeout to
something larger than 300.


--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

AddThis Social Bookmark Button