Post reply

Replication Databses are not Showing

  • September 24, 2013 at 3:43 am

    #283618

    Hi,

    I have some replication databases on some servers and those replicated databases are not showing in my table, i don't find any status of those databases. but i know manually which databases are replicated on servers. on my monitring tool i have quried to show status (replication xps) this is system command. actually in facets replication xps is enabled as a false in my replicated servers.

    can anyone have better idea to find replicated databases, please let me know.

    Cheers,

  • September 25, 2013 at 1:27 am

    #1652976

    Check information from DMVs'like sys.dm_repl_articles for article published and sys.dm_repl_tranhash for transaction being replicated.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

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

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