September 24, 2013 at 3:43 am
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy