記錄檔檢視器Log File Viewer

適用於: 是SQL Server 否Azure SQL Database 否Azure Synapse Analytics (SQL DW) 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

SQL Server Management StudioSQL Server Management Studio 中的記錄檔檢視器是用於存取有關記錄檔中所擷取之錯誤和事件的資訊。Log File Viewer in SQL Server Management StudioSQL Server Management Studio is used to access information about errors and events that are captured in log files.

記錄檔檢視器的優點Benefits of using Log File Viewer

當目標執行個體已離線或無法啟動時,您可以從本機或遠端 SQL ServerSQL Server 執行個體檢視 SQL ServerSQL Server 記錄檔。You can view SQL ServerSQL Server log files from a local or remote instance of SQL ServerSQL Server when the target instance is offline or cannot start. 您可以從 [已註冊的伺服器] 存取離線記錄檔,也可以透過 WMI 和 WQL (WMI 查詢語言) 查詢以程式設計方式存取。You can access the offline log files from Registered Servers, or programmatically through WMI and WQL (WMI Query Language) queries. 如需詳細資訊,請參閱 檢視離線記錄檔For more information, see View Offline Log Files. 下列是您可以使用記錄檔檢視器存取的記錄檔類型:Following are the types of log files you can access using Log File Viewer:

  • 稽核集合Audit Collection

  • 資料收集Data Collection

  • Database MailDatabase Mail

  • 作業記錄Job History

  • 維護計畫Maintenance Plans

  • 遠端維護計畫Remote Maintenance Plans

  • SQL ServerSQL Server

  • SQL Server AgentSQL Server Agent

  • Windows NT (這些是也可以從事件檢視器存取的 Windows 事件)。Windows NT (These are Windows events that can also be accessed from Event Viewer.)

記錄檔檢視器工作Log File Viewer Tasks

工作描述Task Description 主題Topic
描述如何根據想要檢視的資訊來開啟記錄檔檢視器。Describes how to open Log File Viewer depending on the information that you want to view. 開啟記錄檔檢視器Open Log File Viewer
描述如何透過已註冊的伺服器來檢視離線記錄檔,以及如何驗證 WMI 權限。Describes how to view offline log files through registered servers and how to verify WMI permissions. 檢視離線記錄檔View Offline Log Files
提供記錄檔檢視器 F1 説明。Provides Log File Viewer F1 Help. 記錄檔檢視器 F1 說明Log File Viewer F1 Help

另請參閱See Also

SQL Server Audit (Database Engine) SQL Server Audit (Database Engine)
SQL Server Agent 錯誤記錄檔SQL Server Agent Error Log