I have setup a new replication via backup and restore but its giving me two errors first
"the row was not found at the subscriber when applying the replicated command. (source: mssqlserver, error number: 20598)"
and the second one is
Violation of PRIMARY KEY constraint 'NWX_WQMS_PRIMARY'. Cannot insert duplicate key in object 'dbo.NWX_WQMS_QUEUE_MSG'. The duplicate key value is (20, 3, 13031200020600002).
I have googled for both and tried all the options but nothing is working out I also recreated replication from scratch for the one Main db but same thing.
I have started replication on other dbs same way, and they are not having any problems.
should I open a MS ticket ? or is there any other way you can suggest please let me know its my production system.
This is my Production System Please help.
Thank you all in advance