SQL Server Get Database File Information

sql-server-get-database-file-information.sql

-- Get db filenames, paths, sizes and growth info
SELECT DB_NAME(database_id) AS 'Database Name',
	file_id, name, physical_name, type_desc, state_desc,
	is_percent_growth, growth,
	CONVERT(bigint, growth/128.0) AS 'Growth in MB',
	CONVERT(bigint, size/128.0) AS 'Total Size in MB', max_size
FROM sys.master_files WITH (NOLOCK)
ORDER BY DB_NAME(database_id), file_id OPTION (RECOMPILE);