How to change location of errorlog in SQL?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sneha daultani
By default SQL Server ERRORLOG is stored in "C:Program FilesMicrosoft SQL ServerInstanceFolderMSSQLLog" folder. The ERRORLOG location is configured as a startup parameter for SQL Server Service.
To change the location of ERRORLOG you need to modify the startup parameter -e.
Restart SQL Server Service to apply changes.
Is This Answer Correct ? | 0 Yes | 0 No |
How to truncate the log in sql server 2012? : sql server database administration
How the authentication mode can be changed?
How to retrieve field values using mssql_result()?
What are various ways to enhance the ssrs report?
what are the types of indexes? : Sql server database administration
Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer
What is MSDE?
What is difference between count (*) and count column?
what changed between the previous version of sql server and the current version? : Sql server database administration
How many null values we can have in a unique key field in sql server?
What are the steps you should follow to start sql server in single-user mode?
what authentication modes does sql server support? : Sql server database administration