Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hvdtol
Yak Posting Veteran
50 Posts |
 Posted - 2007-11-06 : 09:29:17
|
| Hello,How can i change the location of the Sql Agent errorlog file, sqlagent.outWhen i choose Properties from the Sql Agent page, i can see the location and filename, but i am not able to change it.Is there some starup parm? And how can i apply it?Any help is appreciated.Best regards,hvdtol |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-06 : 09:39:22
|
You have to change it in the Configuration manager, click on SQL Server agent, advanced tab and then you will see it under "Dump Directory".
Future guru in the making. |
 |
|
|
hvdtol
Yak Posting Veteran
50 Posts |
Posted - 2007-11-06 : 10:02:25
|
| Thanks,But i already tried that one. It's the dump directory of the Agent, not the directory for sqlagent.out.After restarting the Agent, the file is still being made on the old location.hvdtol |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-06 : 10:31:02
|
It can be done in the registry, if you want to test it out.HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQL.1\SQLServerAgentIt is in the String value ErrorLogFile. I just changed it on my test box and restarted SQL Agent and it moved the file.
Future guru in the making. |
|
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2007-11-06 : 10:42:58
|
| Expand the SQL Server Agent select Error Logs right click select configure there u can edit the path.RKNAIR |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-06 : 10:51:01
|
quote:
Originally posted by ratheeshknair
Expand the SQL Server Agent select Error Logs right click select configure there u can edit the path.RKNAIR
You are right, this appears to be tied to the registry key I mentioned as the value has changed in there. This is obviously the preferred method.
Future guru in the making. |
|
|
|
hvdtol
Yak Posting Veteran
50 Posts |
Posted - 2007-11-06 : 12:24:42
|
| Thanks eveybody, it works,A bit strange bye the way... It should a startup parameter..regards,hvdtol |
|
|
|
|
|
|
|
|
Change location sqlagent.out