May 1, 2014 at 4:10 pm
Hi all,
any one has encountered this error in replication? I am setting up Transaction replication using backup and restore method. When I am starting Snap Shot agent I am getting below error.
The replication agent has not logged a progress message in 10 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.
Thanks for your help.
May 2, 2014 at 12:23 am
What is error no.?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 2, 2014 at 9:40 am
I don't have any error message. Please take a look at screen shot.
thanks
May 2, 2014 at 9:55 pm
Consider the below as a possible solution;
USE master
exec sp_changedistributor_property
@property = N’heartbeat_interval’,
@value = 5;
GO;
Also, the below article may help better explain and understand your issue...
http://maginaumova.com/the-replication-agent-has-not-logged-a-progress-message-in-10-minutes/
GOODLUCK
May 21, 2014 at 6:52 pm
Not sure. Has the agent account password changed recently? Has disk space on the distributor filled up? Is the transaction log full on the distributor database?
----------------------------------------------------
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply