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.