Saturday, February 9, 2013

Moving the SQLAGENT.OUT file

Moving the SQLAGENT.OUT file:

Question: Is there a way to move the SQLAGENT.OUT ?
Answer: This command moves the location of the file
USE msdb
GO
EXEC msdb.dbo.sp_set_sqlagent_properties @errorlog_file=N'newpath\SQLAGENT.OUT'
GO
Now restart the SQL Agent

No comments: