You can solve (partially) the problem by augmenting the timeout factor in the merge-agent.
Simply open SQL manager, and look into the database you need, under the folder replication manager, and go to the Agents folder. Open the Merge agents subfolder and look for the one which replicates the table(s) you need.
Right click on the merge agent of your choice and select properties.
Go to the Tab Steps and select the step Run Agent. click on Edit and you'll see the merge instruction appear. At the end of this instruction you can insert a timeout factor: -QueryTimeOut 120 (120 seconds).
Save the edited entry and try it out. Try also several timeout factors ( in seconds) for optimal performance.
I hope this helps you!
Originally posted by saleem
We have same database at our Head office and at factory. we use merge replication over internet to synchronize both databases.
The problem is that the internet connection is not good and keep on breaking. Is there some other way to replicate database.