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.
Reference: Ritesh Shah
Note: Microsoft Books online is a default reference of all articles.