Skip to content

Latest commit

 

History

History
47 lines (36 loc) · 2.85 KB

mssql-eng020557.md

File metadata and controls

47 lines (36 loc) · 2.85 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom helpviewer_keywords monikerRange
MSSQL_ENG020557
MSSQL_ENG020557
MashaMSFT
mathoma
09/25/2024
sql
replication
reference
updatefrequency5
MSSQL_ENG020557 error
=azuresqldb-mi-current||>=sql-server-2016

MSSQL_ENG020557

[!INCLUDE SQL Server SQL MI]

Message Details

Attribute Value
Product Name SQL Server
Event ID 20557
Event Source MSSQLSERVER
Component [!INCLUDEssDEnoversion]
Symbolic Name
Message Text Agent shutdown. For more information, see the SQL Server Agent job history for job '%s'.

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 Start and Stop a Replication Agent (SQL Server Management Studio) and Replication Agent Executables Concepts.

  • 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 View Information and Perform Tasks using 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.

Related content