Replication Issues

Question

Replication Issues

dba.sql29

SSCommitted

Points: 1837
More actions
May 1, 2014 at 4:10 pm

#288373

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.

Viewing 5 posts - 1 through 4 (of 4 total)

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

free_mascot One Orange Chip Points: 27169 More actions · Answer 1

What is error no.?

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

dba.sql29 SSCommitted Points: 1837 More actions · Answer 2

I don't have any error message. Please take a look at screen shot.

thanks

akhamoshioke Ten Centuries Points: 1110 More actions · Answer 3

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

MMartin1 One Orange Chip Points: 27795 More actions · Answer 4

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?

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