DanteKingsley
asked on
How do I move SQL Server error log files from the default location?
Hello all, I need to move the SQL Server error logs from the default C: to a different partition. Can someone tell me how to do this? I've goofed around with the configuration manager and just can't quite get it to work.
ASKER
Hi Angel,
How do I do that? I can stop or start it anytime I want. Yes, ERRORLOG files. They're eating up the C: so I want to move them to a D: partition.
Can you tell me how to do this?
How do I do that? I can stop or start it anytime I want. Yes, ERRORLOG files. They're eating up the C: so I want to move them to a D: partition.
Can you tell me how to do this?
Official way:
Go to the SQL Server Configuration Manger Under the SQL Server 2005 Services tab find the SQL Server Service --> Right click --> Properties --> Advanced tab.
Find the Startup Parmaters and change the -e Parameter and change the path. The path must be exist already.
Restart the services.
-------------------------- ---------- -----
Unofficial way (only recommended for the truly skilled or the really really brave):
Find the
HKLM\SOFTWARE\Microsoft\Mi crosoft SQL Server\MSSQL.1\MSSQLServer \Parameter s
registry key and change the "SQLArg1"="-e....." key.
Rester the services.
Go to the SQL Server Configuration Manger Under the SQL Server 2005 Services tab find the SQL Server Service --> Right click --> Properties --> Advanced tab.
Find the Startup Parmaters and change the -e Parameter and change the path. The path must be exist already.
Restart the services.
--------------------------
Unofficial way (only recommended for the truly skilled or the really really brave):
Find the
HKLM\SOFTWARE\Microsoft\Mi
registry key and change the "SQLArg1"="-e....." key.
Rester the services.
-dc:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-ec:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lc:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
ASKER
lol the truely skilled or brave,
Hi Jimpen,
I've been messing with this and don't see the -e on start up parameters. I have a test server to goof with before I try this on the production box.
Can you give me more advice on this? Do I add -e for the start up parameters?
Hi Jimpen,
I've been messing with this and don't see the -e on start up parameters. I have a test server to goof with before I try this on the production box.
Can you give me more advice on this? Do I add -e for the start up parameters?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank You so much !!!!!!!!!!!!!!!!!!!!!!! It worked !!!!!
Glad to be of assistance. May all your days get brighter and brighter.
I see I failed to remember the "obvious" answer here :(
good work, jimpen!
good work, jimpen!
do not fret angel....it is the obvious answers that typically escape me as well. ;)
>> I see I failed to remember the "obvious" answer here :(
Well its either late evening or early morning where you are. You either have had too much Duvel or not enough coffee. ;-)
Been there, done that.
Well its either late evening or early morning where you are. You either have had too much Duvel or not enough coffee. ;-)
Been there, done that.
I do appreciate the Duvel....
sorry for the plenty of <offtopic> here ...
it is indeed late, but no Duvel here (at all). only O-juice ... (maybe that's the problem 8-)
it is indeed late, but no Duvel here (at all). only O-juice ... (maybe that's the problem 8-)
you cannot have them on a different location than mssql installation folder\log ...
only possibility is to mount the log folder to a different drive (requires that you stop sql server)