The materialization status and messages returned when 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. |