Replication - How to tell if transaction has been applied to a subscriber

  • Hi SSC,

    How can you tell that a transaction has been applied to a subscriber via the distribution database? I don't see a flag in any of these tables which are joined by various fields...

    MSrepl_transactions

    MSrepl_commands

    MSdistribution_history

    Thanks,

    AmarettoSlim

  • I found the answer to my own question. For others wondering, connect to the subscriber and run the following:

    USE <subscriber_db>

    GO

    SELECT publisher,publication, distribution_agent,transaction_timestamp

    FROM dbo.MSreplication_subscriptions

    The transaction_timestamp value contains the Log Sequence Number (LSN) for the last transaction applied by replication. Multiple rows per publication indicates parallel distribution streams (a non default setting)

    Thanks!

  • The replication Monitor also helps. Rightclick your pubication and select Launch Replication Monitor.

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply