Replication Monitoring SQL Statements
One way to look at the replication configuration and validate row counts, for example, is to use various replication stored procedures, including the following:
• sp_helppublication
—Information on the publication server
• sp_helparticle
—Article definition information
• sp_helpdistributor
—Distributor information
• sp_helpsubscriberinfo
—Subscriber server information
• sp_helpsubscription
—Subscription information
These stored procedures are all extremely useful for verifying exactly how the replication configuration is really configured. If you execute these stored procedures (from the publication database), you get a great documentation of your complete replication topology that can be included in run books ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.