O'Reilly logo

Guru's Guide to SQL Server Architecture and Internals, The by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required