Interested to Buy Any Domain ? << Click Here >> for more details...
How to change location of errorlog in SQL?
- 2 Answers
- 6115 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
How to name query output columns in ms sql server?
explain different levels of normalization? : Sql server database administration
What are xml indexes?
Explain about remote stored procedure?
What are the steps you should follow to start sql server in single-user mode?
How can you manage sql azure security?
What is single-user mode?
How to include text values in sql statements?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
What is store procedure?
What is transaction server implicit?
Explain trigger and trigger types?
What are sub reports and how to create them?
What are the grouping functions?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
