HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

sql server - NoSync subscriptions will need to be dropped and recreated

Submitted by: @import:stackexchange-dba··
0
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.

Solution

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

Code Snippets

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

Context

StackExchange Database Administrators Q#108558, answer score: 2

Revisions (0)

No revisions yet.