Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2008 Replication error. Expand / Collapse
Author
Message
Posted Friday, October 18, 2013 12:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 4:01 AM
Points: 4, Visits: 190
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.



Post #1505991
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse