How can I check the location of SQL Server log files?

To locate the storage location of SQL Server log files, you can follow these steps:

1. Open SQL Server Management Studio (SSMS).
2. Connect to the SQL Server instance.
3. In the Object Explorer, expand the “Management” node and select “SQL Server Logs”.
4. The location of the SQL Server log files can be seen in the “Summary” pane on the right.

Additionally, you can also check the location of the log files by using the following SQL query statement:

EXEC xp_readerrorlog 0, 1, N'Directory'

This will return the directory path where the SQL Server log files are stored.