從SQL Error Log查看SQL service重啟的原因

2026-09-02 置頂文章

20
0
MSSQL

SQL 預設保留6+1份error log, 每次SQL service重啟時會重新產生

error log實體路徑可以
1. 從SQL configuration manager的啟動參數查看 :

-d, -e, -l 各代表: https://learn.microsoft.com/en-us/sql/tools/configuration-manager/sql-server-properties-startup-parameters-tab?view=sql-server-ver17#required-parameters

2. Errorlog裡的第8行也會記錄實體路徑
*sp_readerrorlog 可以讀取SQL Server 或SQL server agent 的記錄檔 https://learn.microsoft.com/zh-tw/sql/relational-databases/system-stored-procedures/sp-readerrorlog-transact-sql?view=sql-server-ver17

error log裡面會記錄SQL Server為什麼被重啟 (每次SQL Server service啟動時，會起一份新的error log. 所以要看前一份errorlog 才知道SQL service為什麼被關掉)

SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required. -- 因為OS Shutdown

SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required. -- 若是從SQL configuration manager或是從windows service去停的話，就會是這行訊息

回首頁