Check Database Physical File Paths and Sizes in SQL Server – DBA Guide
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.
Continue reading Check Database Physical File Paths and Sizes in SQL Server – DBA Guide