How to change location of errorlog in SQL?
Answer Posted / 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 View All Answers
What is left outer join in sql server joins?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is a hint?
what are the different ways to return the rowcount of a table?
what are isolation levels? : Sql server database administration
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Define a cross join?
how many type of indexing in database?
Define tool Manage Statistics in SQL Server 2000 query ?
what are the different stages of Report Processing?
How to check if stored procedure is running in sql server?
Mention the 3 ways to get a count of the number of records in a table.
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
How to rebuild indexes with alter index ... Rebuild?
What are the steps you can take to avoid “deadlocks”?