logo
Resources SQL Server Change SQL Server ErrorLog File Location

How to Change SQL Server ErrorLog File Default Location

By Hally | Last Updated

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: