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
Comments