View Publication and Subscription Status in Replication Monitor

Microsoft SQL Server Replication Monitor displays status information for publications and subscriptions:

Publication Status Values

The following table shows publication status values and their corresponding icons in priority order.

Status Icon
Error UI icon: error
Performance critical UI icon: warning
Retrying failed command UI icon: replication agent retry
OK none

Subscription Status Values

The following tables show subscription status values and their corresponding icons in priority order. It is possible for a subscription to be in two states at the same time, such as Expiring soon/Expired and Retrying failed command; the highest priority status is displayed.

The status values Performance critical, Expiring soon/Expired, and Uninitialized are warnings. When a warning is displayed, Replication Monitor also displays whether an agent is running. For example, the status could be Running, Performance critical.

Transactional subscriptions

Status Icon
Error UI icon: error
Performance critical UI icon: warning
Expiring soon/Expired UI icon: warning
Uninitialized subscription UI icon: warning
Retrying failed command UI icon: replication agent retry
Not running UI icon: replication agent stopped
Running UI icon: replication agent running

Merge subscriptions

Status Icon
Error UI icon: error
Performance critical UI icon: warning
Long-running merge UI icon: warning
Expiring soon/Expired UI icon: warning
Uninitialized subscription UI icon: warning
Retrying failed command UI icon: replication agent retry
Synchronizing UI icon: replication agent running
Not Synchronizing UI icon: replication agent stopped

Snapshot subscriptions

Status Icon
Error UI icon: error
Expiring soon/Expired UI icon: warning
Uninitialized subscription UI icon: warning
Retrying failed command UI icon: replication agent retry
Synchronizing UI icon: replication agent running
Not Synchronizing UI icon: replication agent stopped

See Also

Monitoring Replication