SQL Server 2008 Replication error.

  • Log Reader agent is not logging any information and currently showing error with red flag.

    if data is not available for replication then the error message should be "No replicated transactions are available.", instead of this logging the below error message.

    Replication Monitor Log

    ---------------------

    The replication agent has not logged a progress message in 5 minutes. This might indicate an unresponsive agent or high system activity. Verify that records are being replicated to the destination and that connections to the Subscriber, Publisher, and Distributor are still active.

    when I start trace token, Immediately replication will be active and after 10 min same above error message.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply