How to: Verify path for SQL Server Error Log Files

Hello Friends,

March has been a busy month, and it is not over yet. Taking some time off to blog; as small find “worth sharing”.

While managing a SQL Server instance, there are so many different locations to look for MSSQL files, like SQL Server Error Logs. While we can easily locate path to SQL Server Error Logs using SSMS (management studio), here’s is an alternate method (Just-In-Case the SQL Management Studio GUI is not avaialble)

SQL SERVER 2008/R2/2005

Using SQL Server Configuration Manager:

SQL Server Configuration Manager is a tool to manage the services associated with SQL Server. The features however are more:

1. On the Start menu, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.

2. In SQL Server Configuration Manager, expand Services, and then click SQL Server

3. In the details pane, right-click the name of the instance you want to start automatically, and then click Properties

4. Click the Advanced tab, and Verify Startup Parameters.

· -e The fully qualified path for the error log file (Refer below screen)SQL_Config_Img 

Other parameters

· -d The fully qualified path master database file

· -l The fully qualified path master database log file

 

As always, for more details on SQL Server Configuration Manager, Refer BOL >> https://technet.microsoft.com/en-us/library/ms174212(SQL.90).aspx

SQL SERVER 2000

Now as we don’t have “SQL Server Configuration Manager” for SQL Server 2000, I need to look for an alternate approach to locate SQL Server Error logs

Using SQL Server Enterprise Manager

1. On the Start menu, point to All Programs, point to Microsoft SQL Server and click Enterprise Manager.

2. Expand Microsoft SQL Servers –> SQL Server Group –> <SQL Server Instance>

3. Right-click on the SQL Server Instance, and then click Properties

4. Click the Startup Parameters tab, and verify Startup Parameters.

· -e The fully qualified path for the error log file (Refer below screen)

image

Now, assuming that Enterprise Manager is not working. Here’s how you still determine the SQL Error Log location….

Using SQL Server Registry Keys

Click Start, click Run, type Regedit, and then click OK.

Locate the following registry subkey:

  • For - Default Instance
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters
  • For - Named Instance
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft SQL Server\<Instance_Name>\MSSQLServer\Parameters

Go Try This !

Disclaimer: I work at Microsoft. Everything here, though, is my personal opinion and is not read or approved by Microsoft before it is posted. No warranties or other guarantees will be offered as to the quality of the opinions or anything else offered here.