Home > Resources > SQL Server > Change SQL Server ErrorLog File Location

How to Change SQL Server ErrorLog File Default Location

Generally, the default directory of ErrorLog file is location you install SQL Server. But if you don’t want to save ErrorLog file there, you can change it and save ErrorLog files in other folder or hard drive.

1. Open SQL Server Configuration Manager. And double-click SQL Server instance.

open SQL Server instance properties

2. In SQL Server instance Properties window, tab Advanced and you can see Dump Directory.

SQL Server ErrorLog file default location

Now the dump directory is the location where all logs save. If you want to change ErrorLog file location, you have to change dump directory. Paste new location instead of default location in Dump Directory parameter box.

change SQL Server ErrorLog file location

3. Click Apply and OK to save changes.

Now SQL Server ErrorLog file location has been changed successfully. When SQL Server runs next time, all errors will be recorded in new location.

 

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 +