Interested to Buy Any Domain ? << Click Here >> for more details...
How to change location of errorlog in SQL?
- 2 Answers
- 6111 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 insert and update data into a table with "insert" and "update" statements?
What are the 7 disadvantages to a manual system?
What is merge statement?
what data regions are and what are the different data regions?
Do you know spatial data types - geometry and geography in sql server 2008?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
What are .mdf files?
How to connect to SQL Azure Database by using sqlcmd?
What is ms sql server triggers?
What happens if null values are involved in boolean operations?
Does transparent data encryption provide encryption when transmitting data across the network?
Please explain what is “asynchronous” communication in sql server service broker?
Explain what is log shipping?
Can primary key be null?
Which is the main third-party tool used in sql server?
