I am having this error message from the sql server replication monitor:

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) Get help: http://help/21074

enter image description here

The publication is SupplierDB.

I have just generated an snapshot, as you can see on the picture below.

enter image description here

I have followed the answers and comments and not sure what else, my subscription is now working, however, it shows up twice now, and I can't find a way to get rid of the one that is not working.

enter image description here

I got it double for some reason. enter image description here

  • 1
    You have to query distribution..MSSubscriptions and check the status column value to be 0 (Inactive). Check my answer here
    – Kin Shah
    Commented Jul 30, 2015 at 13:34

1 Answer 1


You can update the registry of the Subcriber

here you will see the actual status

select * from [Publish_Database]..syssubscriptions

here the update for all articles subscribes

update [Publish_Database]..syssubscriptions set status=2 where srvname='server'

After that the snapshot should become effective again

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.