| Vishal 2006-10-28, 7:14 pm |
| Can anyone help me on this??
I have a transactional replication going on from Server A to server B
(Sql Server 2005)
The replication was working well till yesterday..
But now, the replicated transactions are not getting applied at the
subscriber. When I see the Log reader agent, its working
fine...delivering the transactions to the distributor. When I see the
replication monitor status ..it says 'delivering replicated
transactions'...however the number of undistriuted transactions is very
high..its getting bigger and bigger..not decreasing...I dont see any
errors..So my guess is the distribution agent is not working eventhough
its says 'delivering replicated transactions'..Other thing is if i see
the replication monitor it says status excellent...and latency as 00
...but i dont see the latest data at the subscriber..the subscriber is
way behind the publisher..
can anyone help me on this?? how do i resolve this problem??? I
stopped the distribution agent and again started it..but it dint
help...what should i do??
thanks
|