how do find which table transactions are pending delivery to the subscriber .. we have seen transaction replication latencies with log reader agent ..can you plz explore more about the log reader agent troubleshooting
@ashutoshmishra25654 жыл бұрын
I am using SQL Serve Enterprise Edition (64-bit) and in this i am using transactional-replication with on Publisher , one Replication Distribution Agent with four Subscriber. everything was going smoothly but now when i am seeing my replication in SQL server through replication monitor and clicking on 'subscription watch list' all subscribers status are showing as 'Expiring soon/Expired' and i am not sure why and when i am double clicking on subscriber error message are 'no replicated transactions are available'.please suggest me what to do