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.