How to change location of errorlog in SQL?
Answer Posted / anwar hayat
To change the location of your log backup files, you have
to update whatever process is generating them. If it is a
Maintenance Plan then you can adjust it inside the
Maintenance Plan properties. To change the location of the
SQL Agent log, expand the SQL Server Agent Node in SSMS,
right click the ErrorLogs folder and click Configure, and
change the path there. Or you can do it with TSQL:
Code Snippet
USE [msdb]
GO
EXEC msdb.dbo.sp_set_sqlagent_properties
@errorlog_file=N'D:\Srvapps\Microsoft SQL Server\MSSQL.1
\MSSQL\LOG\SQLAGENT.OUT'
Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
How to create an index on a view?
How to add an address record into adventureworkslt?
Define self join in sql server joins?
State the difference between union and union all?
Explain about unique identifier data type in sql server?
How do you size a resultset?
Is it possible to replicate data from sql server to oracle? : sql server replication
How to create database with physical files specified in ms sql server?
How can you tell if a database object is invalid?
What are the new features are introduced in sql server 2012 reporting services?
What are distributed partitioned views?
what is database replication? : Sql server database administration
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
What is the difference between local and global temporary tables?
What is the difference between clustered and non-clustered indexes in ms sql server?