sql server - NoSync subscriptions will need to be dropped and recreated 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




The publication is SupplierDB.

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



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.



I got it double for some reason.
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