檢視與讀取 SQL Server 安裝程式記錄檔View and Read SQL Server Setup Log Files

每次執行安裝程式會建立的記錄檔都會建立與新時間戳記記錄檔資料夾,位於 %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup Bootstrap\Log\。Each execution of Setup creates log files are created with a new timestamped log folder at %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup Bootstrap\Log\. 時間戳記記錄檔資料夾的名稱格式為 YYYYMMDD_hhmmss。The time-stamped log folder name format is YYYYMMDD_hhmmss. 在自動安裝模式下執行安裝程式時,會在 % temp%\sqlsetup*.log 建立記錄檔。When Setup is run in an unattended mode, the logs are created at % temp%\sqlsetup*.log. 記錄檔資料夾中的所有檔案都會封存到個別記錄檔資料夾的 Log*.cab 檔中。All files in the logs folder are archived into the Log*.cab file in their respective log folder.

典型的安裝程式要求會經過三個執行階段:A typical Setup request goes through three execution phases:

  1. 全域規則文字Global rules text

  2. 元件更新Component update

  3. 使用者要求的動作User-requested action

在每個階段,安裝程式都會產生詳細和摘要的記錄檔,並且會依需要建立其他的記錄檔。In each phase, Setup generates detail and summary logs with additional logs created as appropriate. 每個使用者要求的安裝程式動作都會至少呼叫安裝程式三次。Setup is called at least three times per user-requested Setup action.

資料存放區檔案包含安裝程序所追蹤的所有組態物件的狀態快照,對於疑難排解組態錯誤很有用。Datastore files contain a snapshot of the state of all configuration objects being tracked by the Setup process, and are useful for troubleshooting configuration errors. XML 檔案傾印會針對每個執行階段為資料存放區物件而建立。XML file dumps are created for datastore objects for each execution phase. 這些會儲存在本身的記錄子資料夾的時間戳記記錄檔資料夾下方,如下所示:They are saved in their own log subfolder under the time-stamped log folder, as follows:

  • Datastore_GlobalRulesDatastore_GlobalRules

  • Datastore_ComponentUpdatedDatastore_ComponentUpdated

  • DatastoreDatastore

下列各節描述 [SQL Server]SQL Server 安裝程式記錄檔。The following sections describe [SQL Server]SQL Server Setup log files.

摘要文字Summary Text

總覽Overview

此檔案會顯示安裝期間偵測到的 [SQL Server]SQL Server 元件、作業系統環境、命令列參數值 (如果有指定),以及已執行之每個 MSI/MSP 的整體狀態。This file shows the [SQL Server]SQL Server components that were detected during Setup, the operating system environment, command-line parameter values if they are specified, and the overall status of each MSI/MSP that was executed.

記錄檔組織成下列各區段:The log is organized into the following sections:

  • 執行的整體摘要An overall summary of the execution

  • 執行 [SQL Server]SQL Server 安裝程式所在電腦的屬性和組態Properties and the configuration of the computer where [SQL Server]SQL Server Setup was run

  • [SQL Server]SQL Server 先前安裝在電腦上的產品功能product features previously installed on the computer

  • 安裝版本與安裝套件屬性的描述Description of the installation version and installation package properties

  • 安裝期間提供的執行階段輸入設定Runtime input settings that are provided during install

  • 組態檔的位置Location of the configuration file

  • 執行結果的詳細資料Details of the execution results

  • 全域規則Global rules

  • 安裝狀況專屬的規則Rules specific to the installation scenario

  • 失敗的規則Failed rules

  • 規則報表檔案的位置Location of the rules report file

LocationLocation

位於 %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup Bootstrap\Log\。It is located at %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup Bootstrap\Log\.

若要尋找摘要文字檔中的錯誤,使用 "error" 或 "failed" 等關鍵字搜尋檔案。To find errors in the summary text file, search the file by using the "error" or "failed" keywords.

Summary_engine-base_YYYYMMDD_HHMMss.txtSummary_engine-base_YYYYMMDD_HHMMss.txt

總覽Overview

summary_engine base 檔案與摘要檔案類似,而且是在主要工作流程期間產生的。The summary_engine base file is similar to the summary file and is generated during the main workflow.

LocationLocation

位於 %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup Bootstrap\Log\< YYYYMMDD_HHMM&GT >\。It is located at %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup Bootstrap\Log\<YYYYMMDD_HHMM>\.

Summary_engine-base_YYYYMMDD_HHMMss_ComponentUpdate.txtSummary_engine-base_YYYYMMDD_HHMMss_ComponentUpdate.txt

總覽Overview

元件更新摘要記錄檔與摘要檔案類似,而且是在元件更新工作流程期間產生的。The component update summary log file is similar to the summary file and is generated during the component update workflow.

LocationLocation

位於 %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup Bootstrap\Log\< YYYYMMDD_HHMM&GT >\。It is located at %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup Bootstrap\Log\<YYYYMMDD_HHMM>\.

Summary_engine-base_<VersionNumber>MMDD_HHMMss_GlobalRules.txtSummary_engine-base_<VersionNumber>MMDD_HHMMss_GlobalRules.txt

總覽Overview

全域規則摘要記錄檔與摘要檔案類似,而且是在全域規則工作流程期間產生的。The global rules summary log file is similar to the summary file generated during the global rules workflow.

LocationLocation

位於 %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup Bootstrap\Log\< YYYYMMDD_HHMM&GT >\。It is located at %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup Bootstrap\Log\<YYYYMMDD_HHMM>\.

Detail.txtDetail.txt

總覽Overview

安裝或升級之類的主要工作流程會產生 Detail.txt,並提供執行的詳細資料。Detail.txt is generated for the main workflow such as install or upgrade, and provides the details of the execution. 針對安裝叫用每個動作時,檔案中的記錄會隨著時間而產生,並顯示執行動作的順序及其相依性。The logs in the file are generated based on the time when each action for the installation was invoked, and show the order in which the actions were executed, and their dependencies.

LocationLocation

位於 %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\SetupIt is located at %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup

Bootstrap\Log\<YYYYMMDD_HHMM>\Detail.txt.Bootstrap\Log\<YYYYMMDD_HHMM>\Detail.txt.

如果在安裝程序期間發生錯誤,就會在此檔案的結尾記錄例外狀況或錯誤。If an error occurs during the Setup process, the exception or error are logged at the end of this file. 若要尋找此檔案中的錯誤,請先檢查檔案的結尾,然後再搜尋檔案中的 "error" 或 "exception" 等關鍵字。To find the errors in this file, first examine the end of the file followed by a search of the file for the "error" or "exception" keywords.

Detail_ComponentUpdate.txtDetail_ComponentUpdate.txt

總覽Overview

元件更新工作流程會產生 Detail_ComponentUpdate.txt 檔,而且與 Detail.txt 類似。The Detail_ComponentUpdate.txt file is generated for the component update workflow and is similar to Detail.txt.

LocationLocation

位於 %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup Bootstrap\Log\< YYYYMMDD_HHMM&GT >\。It is located at %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup Bootstrap\Log\<YYYYMMDD_HHMM>\.

Detail_GlobalRules.txtDetail_GlobalRules.txt

總覽Overview

全域規則執行會產生 Detail_GlobalRules.txt,而且與 Detail.txt 類似。Detail_GlobalRules.txt is generated for the global rules execution and is similar to Detail.txt.

LocationLocation

位於 %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup Bootstrap\Log\< YYYYMMDD_HHMM&GT >\。It is located at %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup Bootstrap\Log\<YYYYMMDD_HHMM>\.

MSI 記錄檔MSI log files

總覽Overview

MSI 記錄檔會提供安裝套件程序的詳細資料。The MSI log files provide details of the installation package process. 在指定之套件的安裝期間,MSIEXEC 會產生這些記錄檔。They are generated by the MSIEXEC during the installation of the specified package.

MSI 記錄檔的類型:Types of MSI log files:

  • <功能><架構>_<互動>.log<Feature><Architecture>_<Interaction>.log

  • <功能><架構>_<語言>_<互動>.log<Feature><Architecture>_<Language>_<Interaction>.log

  • <功能><架構>_<互動>_<工作流程>.log<Feature><Architecture>_<Interaction>_<workflow>.log

LocationLocation

MSI 記錄檔位於 %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup Bootstrap\Log\< YYYYMMDD_HHMM&GT >\< 名稱>。 記錄檔。The MSI log files are located at %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup Bootstrap\Log\<YYYYMMDD_HHMM>\<Name>.log.

檔案的結尾是執行的摘要,其中包含成功或失敗狀態以及屬性。At the end of the file is a summary of the execution which includes the success or failure status and properties. 若要尋找 MSI 檔中的錯誤,請搜尋 "value 3",通常就可以在該字串的附近找到錯誤。To find the error in the MSI file, search for "value 3" and usually the errors can be found close to the string.

ConfigurationFile.iniConfigurationFile.ini

總覽Overview

組態檔包含安裝期間提供的輸入設定。The configuration file contains the input settings that are provided during installation. 該檔案可以用來重新啟動安裝,而不必手動輸入設定。It can be used to restart the installation without having to enter the settings manually. 不過,帳號的密碼、PID 與某些參數不會儲存在組態檔中。However, passwords for the accounts, PID, and some parameters are not saved in the configuration file. 這些設定可以加入至檔案,或者使用命令列或安裝程式使用者介面提供。The settings can be either added to the file or provided by using the command line or the Setup user interface. 如需詳細資訊,請參閱 < 安裝 SQL Server 2014 使用組態檔For more information, see Install SQL Server 2014 Using a Configuration File.

LocationLocation

位於 %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup Bootstrap\Log\< YYYYMMDD_HHMM&GT >\。It is located at %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup Bootstrap\Log\<YYYYMMDD_HHMM>\.

SystemConfigurationCheck_Report.htmSystemConfigurationCheck_Report.htm

總覽Overview

系統組態檢查報告包含每個已執行規則以及執行狀態的簡短描述。The system configuration check report contains a short description for each executed rule, and the execution status.

LocationLocation

位於 %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup Bootstrap\Log\< YYYYMMDD_HHMM&GT >\。It is located at %programfiles%\MicrosoftMicrosoft[SQL Server]SQL Server\120\Setup Bootstrap\Log\<YYYYMMDD_HHMM>\.

另請參閱See Also

安裝的如何主題 Installation How-to Topics
安裝 SQL Server 2014Install SQL Server 2014