Sample Header Ad - 728x90

Rows deleted in the subscriber - what to do? - SQL Server Transactional Replication

1 vote
4 answers
5407 views
Someone has delete by mistake a row of a table in the subscribed server/database. I am getting the following error message: > The row was not found at the Subscriber when applying the replicated > (null) command for Table '(null)' with Primary Key(s): (null) (Source: > MSSQLServer, Error number: 20598) Now I have restored the deleted row in the replicated server, but the distributor to the subscriber agent is taking so long to apply the changes (currently nearly 1.5 hours). How can I make it do this update immediately? enter image description here
Asked by Marcello Miorelli (17274 rep)
Dec 22, 2016, 06:57 PM
Last activity: Oct 13, 2023, 07:34 PM