info@techdevops.com | 437-991-3573 | Data Tier Services
TechDevOps.com
Explore Tools
Experts in Microsoft SQL Server, Clusters, Always On, Migrations, ERP, Performance & Cloud



Microsoft SQL Server Replication - Validate Subscriptions
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
2016-03-18








Solutions:



Using Replicaton Monitor:


Navigate to your Publisher, select a Publication, right-click & select Validate Subscriptions





Next, select the appropriate parameters





The output will be displayed in the "All Subscriptions" tab for the Subscription you have selected.




Using T-SQL:

Execute in your Publication DB with the appropriate parameters:

sp_publication_validation


Output:

Generated expected rowcount value of 147068 for SEARCH_1
Generated expected rowcount value of 327511 for SEARCH_2.
Generated expected rowcount value of 502278 for SEARCH_3.
Generated expected rowcount value of 502278 for SEARCH_4.
Generated expected rowcount value of 128861 for SEARCH_5.



Resources:

sp_publication_validation (Transact-SQL)