Posts

Showing posts from January, 2018

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

Image
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