none
How to query or check the type of replication RRS feed

  • Question

  • I have servers with different type of replication setting.

    How to query or check the type of replication especially for  Bi-direction replication, p2p  replication and merge   ?

    Thanks in advance for any helps.

    Tuesday, August 27, 2019 10:24 AM

All replies

  • this is a start.
    select publisher_db, case 
    when publication_type=1 then 'snapshot' 
    when publication_type=0 then 'transactional'
    when publication_type=2 then 'merge' end , sync_method,
    case when allow_queued_tran  =0 then 'normal' else 'updateable subscriptions' end from MSpublications
    
    

    Tuesday, August 27, 2019 12:21 PM
    Moderator
  • Hi sqlman2011,

     

    Run the following query on the distribution database:

     

    SELECT      P.Publication     ,P.Publication_type     ,S.Subscriber_ID     ,S.Update_Mode FROM MSPublications P INNER JOIN MSSubscriptions S     ON P.Publication_ID = S.Publication_ID

     

    Publication_type - 0=Transactional, 1=Snapshot, 2=Merge

     

    Update_mode - 0=Read only, 1=Immediate update, 2=queued update with message queue, 3=Immediate update with queued update as failover using message queue, 4=Queued update with SQL Server queue, 5=Immediate update with queued update as failover using SQL Server queue

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, August 28, 2019 7:50 AM