Interested to Buy Any Domain ? << Click Here >> for more details...
How to change location of errorlog in SQL?
- 2 Answers
- 5998 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 create an index on a view?
How to create dbo table in sql server?
What do you know about normalization and de- normalization?
Explain Normalization and DE normalization
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
List the various tools available for performance tuning?
What is thr feature of change data capture?
What is default constraint in ms sql server?
How do I setup a local sql server database?
How to delete duplicate records based on single column from a table?
What is indexed view?
How many columns can exist together per table?
what is denormalization? : Sql server database administration
What do you understand by coalesce in sql server?
What are scheduled tasks in sql server?
