September 16, 2010 at 8:15 am
I have a replication for which the commands are moving fine from distributor to subscriber but when i insert a tracer token, one out of the 5 subscribers isn't getting the token.... the tracer token tab in replication monitor shows pending for distributor to subscriber latency for this subscription... although any changes made in the articles is replicating just fine...
Anyone has any idea as what the problem could be... this is happening for a 2005 -> 2005 replication and also to a 2008 -> 2008 one... the subscriber and publisher database involved in these two replications are also used in several other replications but i don't see a problem there..
September 16, 2010 at 8:46 am
Have you tried stopping and restarting the subscription?
September 16, 2010 at 9:27 am
yup!! tried stopping the distribution agent job and restarting it again.... also dropped and recreated the subscription... still the problem persists...
September 21, 2010 at 8:46 am
I have a replication for which the commands are moving fine from distributor to subscriber but when i insert a tracer token, one out of the 5 subscribers isn't getting the token.... the tracer token tab in replication monitor shows pending for distributor to subscriber latency for this subscription... although any changes made in the articles is replicating just fine...
Anyone has any idea as what the problem could be... this is happening for a 2005 -> 2005 replication and also to a 2008 -> 2008 one... the subscriber and publisher database involved in these two replications are also used in several other replications but i don't see a problem there..
September 22, 2010 at 6:23 am
this is a design problem... refer this for some details on this...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply