locked
What tables hold Replication metadata? RRS feed

  • Question

  • I setup a Replication test lab with a Subscriber, Publisher and separate Distributor.  (Sql 2914)

    1. What DB and table on the Distributor (?) holds the names of the Publishers the Distributor supports?

    2.What DB and table on the Publisher (?) holds the names of all Subscribers the Publisher supports?

    Or is there a "central" table holding all of this info?

    TIA,

    edm2


    • Edited by edm2 Monday, November 27, 2017 4:03 PM
    Monday, November 27, 2017 4:02 PM

Answers

  • That is correct.
    • Marked as answer by edm2 Monday, November 27, 2017 7:21 PM
    Monday, November 27, 2017 5:21 PM
    Answerer

All replies

  • The publishers will be registered in master.sys.servers where is_publisher=1

    and in the msdb database in the msdb.dbo.MSdistpublishers  table.

    For a list of the subscribers query the syssubscriptions table in the publication database and join it against the sys.servers table in the master database.

    Monday, November 27, 2017 4:16 PM
    Answerer
  • Thanks. let me check this out!

    Regarding

    >>>

    The publishers will be registered in master.sys.servers where is_publisher=1

    and in the msdb database in the msdb.dbo.MSdistpublishers  table.

    >>>

    I presume this query is run on the Distributor. Correct?

    edm2

    Monday, November 27, 2017 5:12 PM
  • That is correct.
    • Marked as answer by edm2 Monday, November 27, 2017 7:21 PM
    Monday, November 27, 2017 5:21 PM
    Answerer