Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replication Databses are not Showing Expand / Collapse
Author
Message
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: Yesterday @ 10:47 AM
Points: 47, Visits: 208
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,
Post #1497734
Posted Wednesday, September 25, 2013 1:27 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
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