Interested to Buy Any Domain ? << Click Here >> for more details...
How to change location of errorlog in SQL?
- 2 Answers
- 6092 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 a cache in ssrs?
How to receive output values from stored procedures?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
please differentiate between delete and truncate?
What are sql azure firewall rules?
What is the difference between value type and reference type?
Do you know what is a trace frag? Where do we use it?
How we can compare two database data?
Scalability, Availability, Integration with internet, etc.)?
What is molap and its advantage? : sql server analysis services, ssas
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
Explain user defined views?
Create and insert into temp table in sql server?
What is an indexed view?
What is data modification?
