Skipping Errors
You can skip errors in transactional replication via the -SkipErrors command line parameter available with the Distribution Agent and the Log Reader Agent. Normally, when these agents are running in continuous mode and encounter an error, the distribution process is aborted. You can use this parameter to specify a colon-delimited list of error numbers that you do not want to interfere with replication. When the agent encounters one of the errors in your list, it will simply log the error in MSrepl_errors and continue running. For an example of how this functionality can be put to good use, see the “Continue on data consistency errors” profile for the Distribution Agent.
Get Guru's Guide to SQL Server Architecture and Internals, The now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
