MSSQL_ENG020557

New: 17 July 2006

Message Details

Explanation

A replication agent has shut down without writing a reason to the appropriate history table, or the agent was shut down while in the middle of a process.

User Action

• Restart the agent to see whether it will now run without failures. For more information, see How to: Start and Stop a Replication Agent (SQL Server Management Studio) and Programming Replication Agent Executables.
• Check the agent history and job history for other errors that occurred around the same time. For information about how to view agent status and error details in Replication Monitor, see the following topics:
  • For the Snapshot Agent, Log Reader Agent, and Queue Reader Agent, see How to: View Information and Perform Tasks for the Agents Associated With a Publication (Replication Monitor).
  • For the Distribution Agent and Merge Agent, see How to: View Information and Perform Tasks for the Agents Associated With a Subscription (Replication Monitor).
• Verify that basic connectivity is working between the computers that are accessed by the agent, and then connect to each computer by using a utility, such as the sqlcmd utility. When you connect, use the same account under which the agent makes connections. For more information about the permissions that are required by each agent account, see Replication Agent Security Model.
• If the error occurs while you are creating or applying a snapshot, check the files in the snapshot directory for errors.
• If the error continues to occur, increase the logging of the agent and specify an output file for the log. Depending on the context of the error, this could provide the steps leading up to the error and additional error messages. For more information about how to configure logging for replication, see the Microsoft Knowledge Base article 312292.

See Also

Concepts

Cause and Resolution of Replication Errors

Help and Information

Getting SQL Server 2005 Assistance