Updated on 2025-06-30 GMT+08:00

Cycling SQL Server Error Logs

Scenarios

You can use a stored procedure to close the current SQL Server error log file and cycle the SQL Server error log extension numbers (just like a server restart). The new error log contains version and copyright information and a line indicating that the new log has been created.

Prerequisites

An RDS for SQL Server DB instance has been connected. You can connect to the DB instance through a SQL Server client. For details, see Connecting to a DB Instance Through a Public Network.

Procedure

Run the following command to cycle the RDS for SQL Server error log:

EXEC [msdb].[dbo].[rds_cycle_errorlog]

After the command is executed, the system displays the following information.