patternsqlMinor
sql server - NoSync subscriptions will need to be dropped and recreated
Viewed 0 times
recreatedneedsqldroppedandwillnosyncserversubscriptions
Problem
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.
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.
Solution
You can update the registry of the Subcriber
here you will see the actual status
here the update for all articles subscribes
After that the snapshot should become effective again
here you will see the actual status
select * from [Publish_Database]..syssubscriptionshere the update for all articles subscribes
update [Publish_Database]..syssubscriptions set status=2 where srvname='server'After that the snapshot should become effective again
Code Snippets
select * from [Publish_Database]..syssubscriptionsupdate [Publish_Database]..syssubscriptions set status=2 where srvname='server'Context
StackExchange Database Administrators Q#108558, answer score: 2
Revisions (0)
No revisions yet.