The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. (Source: MSSQLServer, Error number: 21074),REPLICATION
Distribution Agent job failed with below erro message and the below workaround fixed the issue in my environment
Error messages:
The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. (Source: MSSQLServer, Error number: 21074)
And to check thestatus after above command
USE Distribution GO SELECT STATUS,* FROM [dbo].[MSsubscriptions] WHERE PUBLISHER_DB='PublisherDBNameHere'
use distribution go update MSSubscriptions set [status] = 2 WHERE PUBLISHER_DB='PublisherDBNameHere'
use distribution go exec sp_browsereplcmds
Comments