The subscription(s) have been marked inactive and must be reinitialized. No Sync subscriptions will need to be dropped and recreated.
I got the below error in replication in production environment. This issue occurs at "Distribution Agent" Stage. In order to resolve this issue. We update the status of respective subscription of corresponding publication in Distribution Database. The error message as mentioned below "The subscription(s) have been marked inactive and must be reinitialized. No Sync subscriptions will need to be dropped and recreated." The update query below will make Subscription active. Run all these below queries in "Distribution" database. SELECT * FROM MSSubscriptions WHERE Publication_ID=50 GO EXEC sp_replmonitorhelppublication GO BEGIN TRAN UPDATE MSSubscriptions SET Status=2 WHERE publication_id=50 COMMIT TRAN