Inactive Subscription: The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated


When looking at the replication monitor, a message may appear under the ‘status’ column of the subscription watch tab that displays the message ‘not running/ inactive subscription’

“The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated“

When this message appears, there are two approaches to correcting the error:

Right click on the subscription and re-initialize with the option checked to ‘generate a new snapshot’

Update the status flag on the publication and distribution database to change the status from inactive to active.  This can be accomplished by running the stored procedure Usp_ForceInactiveSubscriberActive.

Advertisements
This entry was posted in Replication. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s