vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/rds/umn/rds_faq_0059.html
Ru, Li Yi f51ec873f3 rds_umn 
Reviewed-by: Wagner, Fabian <fabian.wagner@t-systems.com>
Co-authored-by: Ru, Li Yi <liyiru7@huawei.com>
Co-committed-by: Ru, Li Yi <liyiru7@huawei.com>
2024-06-05 10:42:11 +00:00

3.3 KiB
Raw Permalink Blame History

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.

    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

Parent topic: Log Management