How Can I Obtain Microsoft SQL Server Error Logs Using Commands?¶
Log in to the Microsoft SQL Server client as user rdsuser.
Run the following statement to query error logs:
EXECUTE master.dbo.rds_read_errorlog FileID,LogType,FilterText,FilterBeginTime,FilterEndTime
FileID: indicates the ID of an error log. The value 0 indicates the latest logs.
LogType: indicates the log type. The value 1 indicates error logs and value 2 indicates agent logs.
FilterText: indicates a keyword, which can be NULL.
FilterBeginTime: indicates the start time in queries, which can be NULL.
FilterEndTime: indicates the completion time in queries, which can be NULL.
Example:
EXEC master.dbo.rds_read_errorlog 0,1,'FZYUN','2018-06-14 14:30','2018-06-14 14:31'
Figure 1 shows the query results.
Figure 1 Example query results¶