Validate Subscriptions

Applies to: SQL Server Azure SQL Database

Use the Validate Subscriptions dialog box to specify that subscriptions to a transactional publication should be validated the next time the Distribution Agent for each subscription runs. The results of validation are displayed in Replication Monitor. For more information, see Validate Data at the Subscriber.

Note

Azure SQL Managed Instance can be a publisher, distributor, and subscriber for snapshot and transactional replication. Databases in Azure SQL Database can only be push subscribers for snapshot and transactional replication. For more information, see Transactional replication with Azure SQL Database and Azure SQL Managed Instance.

Options

Validate all SQL Server subscriptions
Select to validate data for all SQL Server subscriptions to this publication.

Validate the following subscriptions
Select if you do not want to validate all subscriptions. Select from the list the subscriptions you want to validate.

Validation Options
Click to access the Subscription Validation Options dialog box, which allows you to specify whether to use row count validation or binary checksum validation.

See Also

Validate Replicated Data