Materialization Status

The materialization status and messages returned when executing check subscription at the primary and replicate Replication Servers.

Materialization Status at Replicate Replication Server
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.
Materialized (subscriptions created with the direct_load option)	Subscription `subscription name` progress: catchup, xx% done, xxxxx commands remaining.
Active	Subscription `subscription name` is ACTIVE at the Replicate.
Active (subscriptions created with the direct_load option)	Subscription `subscription name` progress: initial loading, xx% done, xxxxx commands remaining.
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).
Dropping	Subscription `subscription name` is being dropped.

Materialization Status at Primary Replication Server
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.