replication snapshot agent suspect

Last Post 29 Mar 2007 05:36 AM by dbandee. 4 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
dbandee
New Member
New Member

--
29 Mar 2007 05:07 AM
All of a sudden replication experiencing the following:

1. I ahave transactional replication very simple three publications couple of tables each
2. Yesterday replication failed because of the user error, record got deleted on the subscriber
3. I reinitilized the subscription
4. i ran snapshot and distribution agents
5. Snapshot agen completed and automatically started running next snapshot without me doing anything
6. when i right click on running agen only start option is available

so to me it looks like it is marked aas running but not running???
in about 10 min it fails and reports "agent in suspect"

Did anyone had simular issue? and what should i do

Thanks
dbandee
New Member
New Member

--
29 Mar 2007 05:36 AM
It reads:
The agent is suspect. No response in last 10 min.

But what interesting is that if i start it now, the send time, it will comeplete ant kick off the next one and the next one will fail. and it will go in merry-go-round fasion repeating this erorr.

dbandee
New Member
New Member

--
29 Mar 2007 05:48 AM
Also i have found this article which useless i think
http://support.microsoft.com/kb/285106/en-us
dbandee
New Member
New Member

--
29 Mar 2007 11:33 AM
Snapshot
What happesn is one snapsho marked suspect other two succeded

i start the one that fails it runs for 30 secs succedds and upon completions fires next snapshot agent by itself and then the agent fails (the one that started without my interference)

Thanks
dbandee
New Member
New Member

--
30 Mar 2007 05:06 AM
i dropped and recreated the whole thing, likily i had everything scripted, seems to be working now

Thanks


Acceptable Use Policy
---