Interested to Buy Any Domain ? << Click Here >> for more details...
How to change location of errorlog in SQL?
- 2 Answers
- 6084 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 check status of stored procedure in sql server?
How to create database with physical files specified in ms sql server?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
How to select some specific rows from a table in ms sql server?
How to use subqueries in the from clause in ms sql server?
How to concatenate two binary strings together?
Explain how dts is used to extract, transform and consolidate data?
What is raid? : SQL Server Architecture
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What are the different editions available in sql server 2000?
Is natural join and equi join same?
What is pessimistic concurrency?
What is the difference between varchar and nvarchar datatypes?
What is the use of sign function?
