If all of the servers and Replication Server threads are running, but the subscription is not being created or dropped, use the check subscription command, which returns messages that describe the status of the materialization process.
Execute the check subscription at the primary and replicate Replication Servers. If the primary and replicate Replication Servers are the same Replication Server, you need to execute check subscription only once; check subscription displays separate 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 only 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.
Table 5-1 and Table 5-2 list the messages that can be returned by executing check subscription at the primary and replicate Replication Servers.
Status |
Message |
---|---|
Invalid |
subscription name doesn’t exist. |
Removing |
REMOVING subscription subscription name from system tables at the Replicate. |
Dematerializing |
Subscription subscription name is DEMATERIALIZING at the Replicate. |
Valid |
Subscription subscription name is VALID at the Replicate. |
Validating |
Subscription subscription name is VALIDATING at the Replicate. |
Materialized |
Subscription subscription name has been MATERIALIZED at the Replicate. |
Active |
Subscription subscription name is ACTIVE at the Replicate. |
Activating |
Subscription subscription name is ACTIVATING at the Replicate. |
Qcomplete and Active |
Subscription subscription name is ACTIVE at the Replicate and Materialization Queue has been completed. |
Qcomplete |
Materialization Queue for Subscription subscription name has been completed. |
Active and Qcomplete |
Subscription subscription name is ACTIVE at the Replicate, but Materialization Queue for it has not been completed. |
Defined |
Subscription subscription name has been defined at the Replicate. |
Error |
Subscription subscription name has experienced an unrecoverable error during Materialization or Dematerialization. Please consult the error log for more details. |
Pending |
Other subscriptions are being created or dropped for the same replication definition/database. Subscription subscription name will be processed when previous requests are completed. |
Recovering |
Subscription subscription name has experienced a recoverable error during Materialization or Dematerialization. It will be recovered by Subscription Daemon (dSub). |
Status |
Message |
---|---|
Invalid |
subscription name doesn’t exist. |
Dematerializing |
Subscription subscription name is DEMATERIALIZING at the Primary. |
Valid |
Subscription subscription name is VALID at the PRIMARY. |
Active |
Subscription subscription name is ACTIVE at the PRIMARY. |
Activating |
Subscription subscription name is ACTIVATING at the PRIMARY. |
Defined |
Subscription subscription name has been defined at the PRIMARY. |