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. Connect to the DB instance through the SQL Server client.
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.
Parent topic: Usage of Stored Procedures
- Scenarios
- Prerequisites
- Procedure