Tag: SQL Server file location and size script

I encountered the situation recently where I needed to find the size of the log file, file location. Here is the script, if you remove the WHERE condition you will find the result for all the databases.