MS SQL Server - Changing location of the error log file

Author

Changing location of the error log file

Nancy Lytle

2006-02-28, 8:23 pm

I am a defacto DBA and we have a 2 node clustered (active/passive) SQL
Server. When SQL Server was installed the error log file location used was
the default location. That path lists the local share and not the shared
cluster path. Now if the server has to fail over to the other node, SQL
will not start because the other node cannot find the path.

I want to change the error log location in the start up parameter to point
to the shared path that both nodes have access to, but I want to make sure
that making this change will not mean any downtime.

Will making this path change require SQL Server to restart, or anything else
that would mean it would be off line to end users?

Thanks in advance.

Nancy

Sreejith G

2006-02-28, 8:23 pm

Yes you need to start and stop the instance to take the change into effect ,
try this only unless you have a problem with the default location's drive or
if error logs outgrow their current directories and you need to move them to
another drive.

SqlServer.exe -eerror_log_path

Refer:

http://www.sql-server-performance.c..._parameters.asp

Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]

"Nancy Lytle" wrote:

> I am a defacto DBA and we have a 2 node clustered (active/passive) SQL
> Server. When SQL Server was installed the error log file location used was
> the default location. That path lists the local share and not the shared
> cluster path. Now if the server has to fail over to the other node, SQL
> will not start because the other node cannot find the path.
>
> I want to change the error log location in the start up parameter to point
> to the shared path that both nodes have access to, but I want to make sure
> that making this change will not mean any downtime.
>
> Will making this path change require SQL Server to restart, or anything else
> that would mean it would be off line to end users?
>
> Thanks in advance.
>
> Nancy
>
>
>

Sponsored Links