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?

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  May 27, 2010 at 8:35 am

  #1173356

  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

  May 27, 2010 at 8:55 am

  #1173373

  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

  May 27, 2010 at 10:12 am

  #1173438

  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

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