• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. User Guide
  4. FAQs
  5. Management FAQs
  6. How Can I Obtain Microsoft SQL Server Error Logs Using Commands?

How Can I Obtain Microsoft SQL Server Error Logs Using Commands?

  1. Log in to the Microsoft SQL Server client as user rdsuser.
  2. 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.

    For example, run the following statement to query error logs:

    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