How to change location of errorlog in SQL?

Answers were Sorted based on User's Feedback



How to change location of errorlog in SQL?..

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

How to change location of errorlog in SQL?..

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

Post New Answer

More SQL Server Interview Questions

How to convert a numeric expression from one data type to another?

0 Answers  


How do we return a record set from a Stored Procedure in SQl server 2000?

3 Answers  


tell me what is blocking and how would you troubleshoot it? : Sql server database administration

0 Answers  


What command do we use to rename a db, a table and a column?

0 Answers  


Which table keeps information about stored procedures?

0 Answers  


What is standby servers? Explain types of standby servers.

0 Answers  


Difference between LEN() and DATALENGTH() in sql server ?

0 Answers   HCL,


What are orphan records?

0 Answers  


Explain transaction isolation levels in sql server?

0 Answers  


how many joins we can write if at all we have n no of tables

5 Answers   Tanla Solutions, TS,


Define cursor locking

0 Answers  


What is the use of group by clause?

0 Answers  


Categories