Help Center > > User Guide> Working with RDS for SQL Server> Usage of Stored Procedures> Cycling SQL Server Error Logs

Cycling SQL Server Error Logs

Updated at: May 26, 2020 GMT+08:00

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 Microsoft SQL Server DB instance has been connected. Connect to the DB instance through the Microsoft SQL Server client. For details, see Connecting to a DB Instance Through a Public Network.

Procedure

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

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

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel