Home > Resources > SQL Server > Identify Location of SQL Server ErrorLog File

How to Identify Location of SQL Server Error Log File to View Error

Once SQL Server starts up, there would be an errorlog file created automatically in permanent path in computer. It will record the process you done on SQL Server and how SQL Server responds, especially the errors happening while running SQL Server.

So learn to locate to SQL Server ErrorLog file and analyze the error recorded in ErrorLog file, which could help you to find the reason and solution.

Identify location of SQL Server ERRORLOG file and view error

Generally, if you have never changed SQL Server ErrrorLog file location, it will be saved in installation path by default. C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG

identify SQL Server errorlog file location

And if you want to analyze a strange server, you also could identify SQL Server ErrorLog file location with these ways. One of the easiest ways is to verify SQL Server ErrorLog file path in SQL Server Configuration Manager.

Step 1: Open SQL Server Configuration Manager in SQL Server Configuration Tools.

Step 2: Choose SQL Server Services, right-click on SQL Server instance in right pane, then select its Properties.

choose SQL Server instance properties to configure

Step 3: Select Advanced tab, and turn to Startup Parameters. In the attributed string next to Startup Parameters, look for "-e". And the SQL Server ErrorLog file location is listed following it.

identify errorlog file location in SQL Server startup parameters

SQL Server ERRORLOG file location set in startup parameters

Or you can directly see the ErrorLog file path in Dump Directory.

verify SQL ERRORLOG file location in dump directory

SQL Server ErrorLog file path in dump directory

 

Related Articles:

Hot Categories
Windows Password
Product Key Finder
SQL Password
More +
Hot Articles
4 Ways to Change SQL Server SA Password
SQL Server 2012 SA Password Reset
How to Login SQL Server after SA Account Locked Out
How to Change Server Authentication Mode in SQL Server
How to Enable Mixed Mode Authentication for SQL Server
More +
Latest Articles
How to Correct SQL Login Failed Error after SA Password Forgot
Solve SQL Server Connection Error 26
How to Fix Login Failed to SQL Server
More +
Hot Products
Windows Password Genius
iTunes Password Genius
Product Key Finder
More +