Interested to Buy Any Domain ? << Click Here >> for more details...
How to change location of errorlog in SQL?
- 2 Answers
- 6201 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 are the functions in sql server?
How to create new databases with "create database" statements?
Write a sql query to sort on different column name according to the parameters passed in the function?
How many full-text indexes can a table have?
What is transaction server auto commit?
Explain “row_number()” in sql server with an example?
what are the new features in SSRS?
What is the difference between indexing and hashing?
what is denormalization and when would you go for it? : Sql server database administration
What is role playing dimension with two examples? : sql server analysis services, ssas
What information is maintained within the msdb database?
What is 2nf normalization?
Explain few of the new features of sql server 2008 management studio
Explain tables in SQL Azure?
What do you mean by table and field in sql?
