How to change location of errorlog in SQL?
- 2 Answers
- 5393 Views
- ABC, IBM, I also Faced
- E-Mail Answers
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
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
How to verify a user name with sqlcmd tool?
Define outer join in sql server joins?
How to modify an existing stored procedure in ms sql server?
Which trace flags are enabled in sql server?
How sql server executes a statement with nested subqueries?
What is a fan-out query in SQL Azure?
What is failover clustering overview?
What do you mean by sql server 2005 express management tools?
To which devices can a backup be created and where should these devices be located? : sql server management studio
Why should we go for stored procedures? Why not direct queries?
List out the differences between the clustered index and non-clustered index in sql server?
Explain transaction server implicit?
What is user-defined function?
Why are you getting errors when creating a new odbc dsn?
