SQL Server Performance Forum – Threads Archive

Distribution agent fail for snapshot replication

Due to some troubleshooting issue, i have to unplug the replication
server from LAN but when i plug replication server back on LAN. I got
the error message at distribution agent that "The agent is suspect. No
response within last 10 minutes" while snapshot agent had run
successfully. I have increased polling interval from default 5 sec to
10 sec and set the inactivity threshold 60 minutes for refresh rate and
settings. But When i checked data at subscriber there was nothing in
it. All replicated tables were emptied. There is a red cross on
distribution agent. what should i do? With Regards Ali Raza Perhiyar

Have you restarted the Log reader agent after reconnecting the server? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.

]]>