How to: Read a SQL Server Setup Log File

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

SQL Server Setup creates log files for each SQL Server component during installation; logging starts as soon as Setup.exe is launched.

To read a SQL Server Setup log file

  1. Open Windows Explorer and navigate to the following location:

    <drive>:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\LOG

  2. Open the Summary.txt file. Look through it for error messages.

  3. If you do not find information in the Summary.txt file that tells you what failed, open the SQLSetup*[xxxx]*.cab file in the same root directory.

  4. If this .cab file does not exist, open up the CORE log file from:

    <drive>:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\LOG\Files

    Look at the most recently modified core log: SQLSetup*[xxxx]_[ComputerName]*_Core.log.

  5. If an error was shown in the user interface during Setup, look for this log: SQLSetup*[xxxx][s]_[ComputerName]*_WI.log.

  6. When parsing a SQLSetup_[xxxx] log file, search the file for 'UE 3'. This is short for 'Return Value 3'.

  7. If a component failed during installation, open the log file SQLSetup*[xxxx]_[ComputerName]*_SQL.log, and perform the 'UE 3' search to scan for errors.

See Also

Concepts

How to: View SQL Server Setup Log Files

Help and Information

Getting SQL Server 2008 R2 Assistance