I have two servers running Microsoft SQL 2008 and I am using Merge replication. It uses a push subscription. The other day there was an event that would have caused more rows to be inserted into the database then normal. Between 5,000 and 10,000 rows would have been inserted into three tables over the course of 5 minutes. In the next 14 hours I got about 80 e-mails with this error message:
The Merge Agent failed to retrieve article information for publication 'Lynx'. Increase the -QueryTimeOut parameter and restart the synchronization. When troubleshooting, use SQL Profiler or restart the agent with a higher value for -HistoryVerboseLevel a
After I restarted the agent and reinitialized replication, the errors stopped.
So, how do I increase the -QueryTimeOut parameter? And, will it help prevent this in the future?