info@techdevops.com
TechDevOps.com
Explore Tools
Experts in Microsoft SQL Server Operations, Performance, Replication, Cloud & Migrations



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)