Find Log path for SQL Server 2012

Find Log path for SQL Server 2012

I have observed so many times that many developers don’t know where SQL Server log file is located. Log file is one of the primary places where we can start troubleshooting from. There is one DMV “sys.dm_os_server_diagnostics_log_configurations” available in SQL Server 2012 which helps you to find out the error file location.

 SELECT
 [path],
 is_enabled,
 max_size,
 max_files
 FROM
sys.dm_os_server_diagnostics_log_configurations
 GO

First column in above given query will provide you with the information about Path of log file. Second column will convey whether log is enabled or not. Rest of two columns gives you information about Max file size and max number of files.

If you like this article, do like “Extreme-Advice” page in Facebook.

Reference: Ritesh Shah

http://Extreme-Advice.com

http://www.sqlhub.com

Note: Microsoft Books online is a default reference of all articles.

One thought on “Find Log path for SQL Server 2012

Comments are closed.