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

Set the number of SQL Server error logs and find the SQL Server installation error logs. In the forum, I often see someone asking for help because of SQL Server Installation Problems, however, they did not send the error Installation Log to the forum. I personally feel that it is so general that it is difficult for the attacker to find the problem in the Forum. My machine is Windows7Ulti.

Set the number of SQL Server error logs and find the SQL Server installation error logs. In the forum, I often see someone asking for help because of SQL Server Installation Problems, however, they did not send the error Installation Log to the forum. I personally feel that it is so general that it is difficult for the attacker to find the problem in the Forum. My machine is Windows 7 Ulti.

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

I often see someone asking for help in the forum because of SQL Server Installation Problems, but they didn't send the error Installation Log to the Forum.

I personally feel that it is difficult for the attacker to find the problem in the Forum.

My machine: Windows 7 Ultimate SQLSERVER2005 Developer Edition

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 Files \ Microsoft SQL Server \ 90 \ Setup Bootstrap \ LOG \ Files

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 Files \ Microsoft SQL Server \ 90 \ Setup Bootstrap \ LOG \ Files Folder

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

If you have any installation problems, click here 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 Files \ Microsoft SQL Server \ MSSQL.1 \ MSSQL \ LOG

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.

Okay, some heroes may think it's very easy to sleep. I also welcome you to shoot bricks.No bricks, no progressWell(No brother or basketball !!)