SQL Server Performance

Distribution agent fail for snapshot replication

Discussion in 'Performance Tuning for SQL Server Replication' started by perhiyar, Jul 11, 2006.

  1. perhiyar New Member

    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
  2. satya Moderator

    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.

Share This Page