Moving the SQLAGENT.OUT file

Question

Post reply

Moving the SQLAGENT.OUT file

lulu_lutz

SSCrazy

Points: 2155
More actions
May 27, 2010 at 7:35 am

#145152

Is there a way to move the SQLAGENT.OUT without restarting?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

george sibbald SSC Guru Points: 104210 More actions · Answer 1

this command moves the location of the file

USE msdb

GO

EXEC msdb.dbo.sp_set_sqlagent_properties @errorlog_file=N''new path\SQLAGENT.OUT'

GO

Sqlagent will need restarting to write to this new location though. what's the problem with restarting the agent?

---------------------------------------------------------------------

lulu_lutz SSCrazy Points: 2155 More actions · Answer 2

I had to move the system databases and log files to free up a directory last night. The error logs and sqlagent.out were on the same directory as the databases, but I thought changing the dump file location for the SQLSERVER service, would change the location of the error log and SQLAGENT.OUT, but it didn't.

So I was trying to find a way to move it without another downtime.

george sibbald SSC Guru Points: 104210 More actions · Answer 3

sorry, no can do, but a restart of just SQLAgent should not affect the app.

move the errorlog via the startup parameters in config manager, that will require a SQL restart

---------------------------------------------------------------------