Post reply

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

  • October 8, 2013 at 3:02 pm

    #299479

    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

  • October 8, 2013 at 3:33 pm

    #1656931

    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!

  • October 21, 2013 at 1:56 am

    #1660043

    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 2 (of 2 total)

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