How to find the records that are waiting to be replicated?
0
votes
1
answer
245
views
I had a look using the replication monitor and it is showing me commands that are awaiting to be replicated:
My question is - how do I find out what these commands are?
I Have tried this query by Ben Anderson
select @@Servername,a.publication + ':' + s.srvname as [Agent],
v.undelivcmdsindistdb,
v.delivcmdsindistdb,
a.id
from distribution.dbo.msdistribution_status v
join distribution.dbo.msdistribution_agents a on v.agent_id = a.id
join master.dbo.sysservers s on a.subscriber_id = s.srvid
where v.undelivcmdsindistdb > 0
But the number does not exactly match, although it is definitely a good start,
is there a way I can find more info about these records?


Asked by Marcello Miorelli
(17274 rep)
Dec 11, 2023, 10:48 AM
Last activity: May 7, 2024, 03:14 PM
Last activity: May 7, 2024, 03:14 PM