August 12, 2004 at 2:38 pm
i had a message with this description ..the row wasnt found at the suscriber when applied the replication command or something like that .
i delete 26 rows from the suscriber with delete from tablename where clauses
QUESTION how to restore this 26 rows using log , another way to do , thks in advance
August 16, 2004 at 11:15 am
I've found it happens when someone deletes rows from the subscriber 'by accident'. Easiest way to fix is to either do a new snapshot (very brute force, but effective), or add the missing rows back manually to the subscriber (kinda brute force, but easy), or you can use the -skiperrors flag on the agent so that it will run and not break, or you could alter the proc on the subscriber to create the row if missing or just exit without an error if missing.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply