Get DB file info and sizes

span class="re5"> use [master]
go

declare @k2DbName nvarchar(255) = 'K2';

select d.name [DB Name], f.name [File Name], f.physical_name, f.type_desc, f.size
from sys.databases d
inner join sys.master_files f on f.database_id = d.database_id
where d.name = @k2DbName
order by f.type, f.file_id