Transactional Replication
Stock
Hi,
I'm setting up a Sql Server 2000 to do transactional replication. But the
Snapshot Agent and the Log Reader always failed with error "The agent is
suspect. No response within 10 minutes". I have tried it for a few times,
including remove the Distributor, Publisher, Publication, and Subscriber,
then reconfigure it again, but still doesn't work.
I have tried the same configure steps with another SQL Server, it works
without any problem.
Anyone encounter this kind of problem? Any solution?
Thx
Eric Yang [MS]
Based on the error message 'The agent is suspect. No response within the
last 10 minutes', the inactivity threshold is set to 10 minutes. Inactivity
threshold is the time for which an agent has not logged any activity and is
considered as not functioning. If replication is involved in large
transactional volumes, increase the time limit to a large value. This value
can be set through the replication monitor refresh rate and settings in SQL
Server Enterprise Manager.
If you increase the time and the issue still occurs, please use some
anti-virus software to check if there is any virus on your SQL Server.
In addition, you can also refer to the following Microsoft Knowledge Base
article to enable the replication agent output in order to get more hints
regarding this issue.
312292.KB.EN-US: HOW TO: Enable Replication Agents for Logging to Output
Files in SQL Server
http://support.microsoft.com/default.aspx?scid=KB;EN-US;312292
Sincerely,
Eric Yang [MS]
Microsoft Support
Please do not send email directly to this alias. This is our online
account name for newsgroup participation only.
This posting is provided 'AS IS' with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security