I was in a task of configuring Merge replication on SQL Server 2005. But unfortunately, during the synchronization(took around 8 hours) i encountered an error stating "The Merge Agent failed to enumerate retry information. This can occur when there is too much activity on the tempdb system database. Increase the -QueryTimeOut parameter and restart the synchronization."
what does it mean? why it happened? How i can resolve it?
Initially i tired ti configured a pull subscription and got the error. When i tried Push subscription, that issue was resolved. Now i m in to a new problem, I got the following issues
My publisher is running under non trusted environment and my subscriber is on trusted.
This might happen if you have records in the child tables referencing subscriber parent records which no longer exist. You can try to run the agent with
The output verbose level should be 0, 1, or 2:
It goes without saying that these switches have a very negative impact on performance, but in your case, they might be useful to identify the actual source of the problem as it is entirely possible that the problem has nothing to do with FK integrity violations and could be something else. I don't believe though that it has anything to do with the tempdb activity (despite what the error message says).
answered Nov 16, 2010 at 09:15 AM