Validate All Subscriptions

Use the Validate All Subscriptions dialog box to specify that all subscriptions to a merge publication should be validated the next time the Merge Agent for each subscription runs. The results of validation are displayed in Replication Monitor. For more information, see How to: Validate Data at the Subscriber (SQL Server Management Studio).

It is also possible to validate a single subscription by right-clicking a subscription in SQL Server Management Studio and clicking Validate Subscription.

Options

  • Verify the row counts only
    Select to validate whether the table at the Subscriber has the same number of rows as the table at the Publisher. This method does not validate that the content of the rows matches. Row count validation provides a lightweight approach to validation that can make you aware of issues with your data.

  • Verify the row counts and compare checksums to verify the row data
    In addition to taking a count of rows at the Publisher and Subscriber, a checksum of all the data is calculated using the binary checksum algorithm introduced in SQL Server 2000. If the row count fails, the checksum is not performed. Select this option only if all Subscribers are SQL Server 2000 or later; this option is not valid for SQL Server Compact 3.5 SP2.

See Also

Concepts