Set the number of SQLSERVER error logs and find SQLSERVER installation error logs

Find the SQL Server installation error log

If we can post logs to the Forum, the problem should be solved quickly. Next we will talk about the location where SQL Server installation logs are stored.

My SQLSERVER installation on drive C:

C: Program FilesMicrosoft SQL Server90Setup BootstrapLOGFiles

The path may be different from mine.

This folder contains detailed installation logs of each module component during SQL Server installation.

If you are stuck during the installation process, you can click an item and the SQL will pop up the corresponding log file. In fact, the log file

It is also called in the C: Program FilesMicrosoft SQL Server90Setup BootstrapLOGFiles folder.

 

The detailed log file information will not be analyzed, too much, and I am not very professional.

As long as you encounter installation problems, click here as shown in the figure above to call out the log file and send it to the forum.

Set the number of SQL Server error logs

As you know, there are only seven error log files in SQLSERVER. Each time you restart the SQL service, the oldest one will be deleted.

Put my error log file in this path: C: Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOG

You may be different from me.

Generally, when you place SQLSERVER on the server, the SQL service is rarely restarted or the server is restarted.

But what if it's your own laptop? Every day, restarting the computer is equivalent to restarting the SQL service. Then, the earliest error log file will be deleted.

The following steps are all configured in SSMS:

I set the maximum number of error log files to 10.

 

Then I restarted the SQL service.5 timesAnd keep10Error log, why not11What about it? Because the first one is in use, it is not an archive error log.

In this way, after I restart my computer, I can save a certain number of error logs for myself to trace some SQL errors. You can check the size of these error log files and the disk size.

To set the maximum number of error log files. Of course, these error log files cannot move their locations unlike the database data files and transaction log files,

It can only be in the same installation directory as SQL.