Article ID: 2861456 - View products that this article applies to.
Assume that you have a Microsoft SQL Server 2008 R2 or SQL Server 2012 Transactional Replication environment. There are multiple distribution instances of SQL Server in the environment. In this situation, an access violation may occur, and the SQL Server replication distribution agent crashes. Additionally, a mini dump file is generated.
After you apply the hotfix, the agent will shut down gracefully instead of crashing together with a dump file. You can add an additional job step in the Distribution Agent job to restart the agent automatically when the agent has stopped and has the "scheduled for restart" status.
For more information about how to add an additional job step in the Distribution Agent job, please refer to the More Information section.
The issue was first fixed in the following cumulative update of SQL Server.
Cumulative Update 11 for SQL Server 2012
Contact us for more help
Connect with Answer Desk for expert help.