Maintenance: How to change SQL Server Error Log location.

1)  Open SQL Server configuration manager as below

• Start -> All Programs -> Microsoft SQL Server <2005/2008/2012> -> Configuration Tools
• you will see services as below,

              

2)  Now right click SQL Server service and select properties. Go to advanced tab and expand 'Startup Parameters'. Now update the error log new location which is followed by switch ' -e '. Sample screenshots are as below, (make sure there are no spaces added before or after the path, follow the default standards)

Before Change:

After Change: 

           Here the location has been updated from 'Q:\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG' to

'D:\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'  

           

3) The changes will take effect only after restarting SQL Server services. Now restart SQL Services and you should see the SQL Server error logs are being created at new location.