Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Replication Databses are not Showing Expand / Collapse
Posted Tuesday, September 24, 2013 3:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, December 5, 2014 8:50 AM
Points: 47, Visits: 219

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.

Post #1497734
Posted Wednesday, September 25, 2013 1:27 AM


Group: General Forum Members
Last Login: Thursday, March 17, 2016 5:13 AM
Points: 2,796, Visits: 2,232
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."
Post #1498157
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse