SQL SERVER - Find the Size of Database File - Find the Size of Log File - SQL Authority with Pinal Dave
"SELECT DB_NAME(database_id) AS DatabaseName, Name AS Logical_Name, Physical_Name, (size*8)/1024 SizeMB FROM sys.master_files WHERE DB_NAME(database_id) = 'AdventureWorks'"