Interested to Buy Any Domain ? << Click Here >> for more details...
How to change location of errorlog in SQL?
- 2 Answers
- 5974 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
Write a sql query to sort on different column name according to the parameters passed in the function?
What are a scheduled jobs or what is a scheduled tasks?
How to assign null values to variables or columns?
Can coalesce return null?
Explain few examples of stored procedure over triggers?
What is a View ? Can we insert, Update and delete a view?
What is the difference between commit and rollback?
What is the maximum size of sql server database?
Explain filestream storage of sql server 2008?
What do you mean by 'normalization'?
Why the trigger fires multiple times in single login?
Explain the functionalities that views support?
What is sqlservr.exe - process - sql server (sqlex?press)?
How to enforce security in sql server? : sql server security
What is provisioning, billing and metering, and connection routing concepts in the service layer?
