SQL Server – Location of Installation Log file

Varinder Sandhu SQL, SQL-Advanced, SQL-General, SQL-Tips and Tricks, Varinder Sandhu

A few times we were trying to locate the installation log file folder if we faced any issue or problem while installation of SQL Server.

Basically, we want to know reason of issue or problem.

So location of Log file folder as below

SQL Server 2008 and 2008 R2

%programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\

SQL Server 2005

%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\

You can find the Summary.txt file in above mentioned location. This file shows the 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.

To find errors in the summary text file, search the file by using the “error” or “failed” keywords.

For more detail you can refer the MSDN