MS SQL Server - problem with distribution agent-

Author

problem with distribution agent-

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

Hilary Cotter

2006-10-28, 7:14 pm

If replication monitor says the health is excellent it means that it thinks
everything is working well.

Issue this command in your distribution database to see what commands are in
the queue
sp_browsereplcmds

You may find that you have done a mass update which affects several thousand
or million rows which have created this large queue.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Vishal" <rvishal1305@gmail.com> wrote in message
news:1162009320.010431.7230@b28g2000cwb.googlegroups.com...
> 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
>

Sponsored Links