Menu
Amazon Relational Database Service
User Guide (API Version 2014-10-31)

Microsoft SQL Server Database Log Files

You can access Microsoft SQL Server error logs, agent logs, trace files, and dump files by using the Amazon RDS console or APIs. For more information about viewing, downloading, and watching file-based database logs, see Amazon RDS Database Log Files.

Retention Schedule

Log files are rotated each day and whenever your DB instance is restarted. The following is the retention schedule for Microsoft SQL Server logs on Amazon RDS.

Log Type Retention Schedule

Error logs

A maximum of 30 error logs are retained. Amazon RDS may delete error logs older than 7 days.

Agent logs

A maximum of 10 agent logs are retained. Amazon RDS may delete agent logs older than 7 days.

Trace files

Trace files are retained according to the trace file retention period of your DB instance. The default trace file retention period is 7 days. To modify the trace file retention period for your DB instance, see Setting the Retention Period for Trace and Dump Files.

Dump files

Dump files are retained according to the dump file retention period of your DB instance. The default dump file retention period is 7 days. To modify the dump file retention period for your DB instance, see Setting the Retention Period for Trace and Dump Files.

Viewing the SQL Server Error Log by Using the rds_read_error_log Procedure

You can use the Amazon RDS stored procedure rds_read_error_log to view error logs and agent logs. For more information, see Using the rds_read_error_log Procedure.

Related Topics