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?

Asked by Marcello Miorelli
(17274 rep)
Dec 22, 2016, 06:57 PM
Last activity: Oct 13, 2023, 07:34 PM
Last activity: Oct 13, 2023, 07:34 PM