Using the rds_read_error_log Procedure on AWS RDS SQL Server

To view Microsoft SQL server error and agent logs, use the Amazon RDS stored procedure rds_read_error_log with the following parameters:

 

@index – the version of the log to retrieve. The default value is 0, which retrieves the current error log. Specify 1 to retrieve the previous log, specify 2 to retrieve the one before that, and so on.

 

@type – the type of log to retrieve. Specify 1 to retrieve an error log. Specify 2 to retrieve an agent log.

 

Example

 

The following example requests the current error log.

 

EXEC rdsadmin.dbo.rds_read_error_log @index = 0, @type = 1;