check subscription

The check subscription command returns messages that describe the status of the materialization process. Use this command if all of the servers and Replication Server threads are running but the subscription is not being created or dropped.

Execute check subscription at the primary and replicate Replication Servers. If the primary and replicate Replication Servers are the same Replication Server, execute check subscription only once; check subscription shows separate primary and replicate status messages.

Use check subscription for publication to find out the materialization status of publication subscriptions. For atomic, nonatomic, or incremental publication subscriptions, check subscription for publication shows the status of the current article subscription being processed; whereas for bulk or no materialization, the status of all article subscriptions is shown because all article subscriptions are processed together.