Check SQL Server Installation errors by viewing log files

Those who have installed SQL Server are deeply touched by the installation process. In fact, the installation error can be checked by checking the log file. The following describes how to view the installation error. If you want to check the log file for errors, you can easily talk about the SQL Server database files.

SQL Server creates databases based on operating system files. Data and log information are stored in different files, and they are not mixed. SQL Server uses three different types of files: primary data files, secondary data files, and log files.

* Primary Data File: Refers to the most important file in the database, pointing to other database files, including the data information of the database. The extension is usually. MDF.

* Secondary data files: Data Files other than primary data files are secondary data files. A database can have multiple secondary database files or none. The extension is usually. NDF.

* Log files: Used to store log information. Each database must have a log file. The extension is usually. LDF.

The log file sqlstp. log is located in the \ windows or \ WINNT folder and provides installation instructions.ProgramInformation about the current operation and all errors encountered during installation. In the installation configuration section, the SQL server2000installer runs cnfgsvr.exe to configure SQL Server. This application starts SQL Server and runs the initialization installation script. All errors encountered in this process are written into the sqlstp. log file.

You can view the log file to view the problems encountered during installation.

Setup. Log
File: It is located in the \ windows or \ WINNT folder. This file indicates whether the installation is complete or fails. You can use the searchsetup. Log File to check whether the installation is successful or fails. The searchsetup. log file is located in the \ winnt \ Temp folder, which records errors encountered in Microsoft search service configuration. The errorlog file mainly records configuration errors. Errorlog is the latest error log, which is located in the \ log directory of the target installation directory. For example, the default location of the error log is c: \ Program Files \ Microsoft SQL Server \ MSSQL \ log \ errorlog. for named instances, the error log will be in \ Microsoft SQL Server \ MSSQL $ Instance name \ log \ errorlog. this error log contains all the errors encountered when the installation program tries SQL Server.

you can view the error log to check the installation error.