August 23, 2011 at 4:08 am
Hi All,
How to skip the errors during replication, in order to avoid failure of replication. Let say example in transactional replication, if i delete the row at the subscriber and then if we delete the same row at publisher then replication throws error like row not found i want to skip this kind of error. How to achieve this?
Thanks & Regards
Deepak A.
August 23, 2011 at 6:00 am
Add the -SkipErrors parameter to the Distribution Agent of a specific subscription.
August 23, 2011 at 8:14 am
Why would you delete the row at the subscriber if it was one way replication?
Another way would be to re-insert the row at the subscriber then delete from the publisher. Another, edit the sp_msdel_<tablename> and comment out the raiserror lines (does it really matter it a delete row fails because it doesnt exist?).
August 23, 2011 at 10:51 pm
MysteryJimbo (8/23/2011)
Why would you delete the row at the subscriber if it was one way replication?
It is not intentional , if someone unknowingly deletes then we may get this kind of situation to handle this i have asked the solutions.
Another way would be to re-insert the row at the subscriber then delete from the publisher. Another, edit the sp_msdel_<tablename> and comment out the raiserror lines (does it really matter it a delete row fails because it doesnt exist?).
we can try this i think but it is overhead to do ?
August 24, 2011 at 4:56 am
It is and overhead, but if its unintentional how frequently do you expect them?
If users are correctly configured with permissions its quite likely you could prevent inadvertant deletions.
Skip errors at the distribution agent will merely mask errors making it look like everything is ok. IMO you are better off addressing the root cause
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply