Get Filenames and Database names from MSSQL

I was doing some clean up on one of our database servers; we have many databases created with backup/restore for testing purposes I was checking for the largest ldf files and making sure those databases were in simple mode and then shirking the data files, there were a few files I could not match to the databases because the mdf and ldf file names were different from the actual database file name - found the following queries using a few google searches

	-- mssql 2000
	SELECT db_name(dbid), *
	FROM master.dbo.sysaltfiles
	ORDER BY size DESC

view raw gistfile1.sql hosted with ❤ by GitHub

	-- mssql 2005 and above (untested)
	SELECT db_name(database_id) database_name, *
	FROM sys.master_files

view raw gistfile1.sql hosted with ❤ by GitHub