Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL Event Log file locations

Author  Topic 

WJHamel
Aged Yak Warrior

651 Posts

Posted - 2014-02-26 : 13:09:19
Is there a default location that MSSQL2k8R2 stores the .log files that are used under Management/SQL Logs in management studio?

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2014-02-27 : 14:39:36
The default location of the error and SQL logs is the same root where the system databases were installed.

If you installed a default instance with the defaults location - they would be in C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL

In that folder you will find the log folder which will have the log files.

Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-03-03 : 01:47:25
You can use SQL Server xp_regread with T-SQL for SQL Error Log Path and Home Path - http://www.sqlserver-dba.com/2008/08/manipulating-re.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -