How to change location of errorlog in SQL?
- 2 Answers
- 5435 Views
- ABC, IBM, I also Faced
- E-Mail Answers
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
What is SQL Azure Federations?
Does sql server 2000 full-text search support clustering?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
Do you know what are the properties of the relational tables?
What does man by sql wildcard characters in sql server?
How to find tables without indexes?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What is use of dbcc commands?
How to copy data from one table to another table?
What is a cube? : sql server analysis services, ssas
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
Please illustrate physical database architecture? : SQL Server Architecture
What does it mean to be in union?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What is 2nf example?
