Pushing MS SQL RDS Logs to Cloudwatch

Hello.

1. Error Logs: ** Purpose: Error logs contain information about critical errors and issues that occur within SQL Server. They are essential for troubleshooting problems and identifying issues that may impact the database's functionality. ** Content: Error logs typically include error messages, severity levels, timestamps, and a brief description of the problem. They are essential for diagnosing and resolving issues that could potentially affect the SQL Server instance. ** Frequency: **Error logs are generated automatically whenever a critical error occurs, and they can accumulate over time. SQL Server retains a specified number of error log files, and older ones are automatically recycled.
2. Agent Logs: ** Purpose:** SQL Server Agent is a component that allows you to automate various tasks within SQL Server, such as running jobs, backups, and maintenance tasks. Agent logs contain information related to the SQL Server Agent service's activities and the execution status of scheduled jobs and tasks. ** Content:** Agent logs include information about job history, job steps, execution duration, and status (success, failure, etc.). These logs are helpful for monitoring and auditing scheduled tasks and jobs in SQL Server. ** Frequency: **Agent logs are generated based on the execution of scheduled jobs and tasks. They provide a historical record of these activities.

This documentation must help you with correct configuration for RDS logs https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Concepts.SQLServer.html

Best regards, Andrii