查看和阅读 SQL Server 安装程序日志文件View and Read SQL Server Setup Log Files

每次执行安装程序中创建的日志文件与新的时间戳的日志文件夹位于 %programfiles%\MicrosoftMicrosoftSQL ServerSQL Server\120\Setup Bootstrap\Log\。Each execution of Setup creates log files are created with a new timestamped log folder at %programfiles%\MicrosoftMicrosoftSQL ServerSQL 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 ServerSQL Server 安装程序日志文件。The following sections describe SQL ServerSQL Server Setup log files.

摘要文本Summary Text

概述Overview

此文件显示在安装过程中检测到的 SQL ServerSQL Server 组件、操作系统环境、命令行参数值(如果已指定),以及执行的每个 MSI/MSP 的总体状态。This file shows the SQL ServerSQL 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 ServerSQL Server 安装程序的计算机的属性和配置Properties and the configuration of the computer where SQL ServerSQL Server Setup was run

  • SQL ServerSQL 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%\MicrosoftMicrosoftSQL ServerSQL Server\120\Setup Bootstrap\Log\。It is located at %programfiles%\MicrosoftMicrosoftSQL ServerSQL 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 基本文件类似于摘要文件,是在主工作流中生成的。The summary_engine base file is similar to the summary file and is generated during the main workflow.

LocationLocation

位于 %programfiles%\MicrosoftMicrosoftSQL ServerSQL Server\120\Setup Bootstrap\Log\< YYYYMMDD_HHMM >\。It is located at %programfiles%\MicrosoftMicrosoftSQL ServerSQL 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%\MicrosoftMicrosoftSQL ServerSQL Server\120\Setup Bootstrap\Log\< YYYYMMDD_HHMM >\。It is located at %programfiles%\MicrosoftMicrosoftSQL ServerSQL 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%\MicrosoftMicrosoftSQL ServerSQL Server\120\Setup Bootstrap\Log\< YYYYMMDD_HHMM >\。It is located at %programfiles%\MicrosoftMicrosoftSQL ServerSQL 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%\MicrosoftMicrosoftSQL ServerSQL Server\120\SetupIt is located at %programfiles%\MicrosoftMicrosoftSQL ServerSQL 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. 若要查找该文件中的错误,请首先检查文件末尾,然后在文件中搜索“错误”或“异常”关键字。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%\MicrosoftMicrosoftSQL ServerSQL Server\120\Setup Bootstrap\Log\< YYYYMMDD_HHMM >\。It is located at %programfiles%\MicrosoftMicrosoftSQL ServerSQL 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%\MicrosoftMicrosoftSQL ServerSQL Server\120\Setup Bootstrap\Log\< YYYYMMDD_HHMM >\。It is located at %programfiles%\MicrosoftMicrosoftSQL ServerSQL 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:

  • <Feature><Architecture>_<Interaction>.log<Feature><Architecture>_<Interaction>.log

  • <Feature><Architecture>_<Language>_<Interaction>.log<Feature><Architecture>_<Language>_<Interaction>.log

  • <Feature><Architecture>_<Interaction>_<workflow>.log<Feature><Architecture>_<Interaction>_<workflow>.log

LocationLocation

MSI 日志文件位于 %programfiles%\MicrosoftMicrosoftSQL ServerSQL Server\120\Setup Bootstrap\Log\< YYYYMMDD_HHMM >\< 名称>。 日志。The MSI log files are located at %programfiles%\MicrosoftMicrosoftSQL ServerSQL 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%\MicrosoftMicrosoftSQL ServerSQL Server\120\Setup Bootstrap\Log\< YYYYMMDD_HHMM >\。It is located at %programfiles%\MicrosoftMicrosoftSQL ServerSQL 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%\MicrosoftMicrosoftSQL ServerSQL Server\120\Setup Bootstrap\Log\< YYYYMMDD_HHMM >\。It is located at %programfiles%\MicrosoftMicrosoftSQL ServerSQL Server\120\Setup Bootstrap\Log\<YYYYMMDD_HHMM>\.

请参阅See Also

安装操作指南主题 Installation How-to Topics
安装 SQL Server 2014Install SQL Server 2014