Interested to Buy Any Domain ? << Click Here >> for more details...
How to change location of errorlog in SQL?
- 2 Answers
- 5982 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
What is sql server programming?
How to create a new table in a given schema?
Do you know how to make remote connection in database?
What is page in sql server?
Explain transaction server explicit transaction?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is rs.exe utility?
Explain log shipping and mention its advantages.
Do you know what is difference between index seek vs. Index scan?
How many tables can be joined in SQL Server?
How self join is different from outer join?
What does sql server mean?
Tell me about the approaches which you used to counter the DI problems.
What is sql server transaction log file?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
