If you want to check the name of the files and their respective sizes for the given database then following are two quick tsql scripts:
1. Use sp_helpfile
This stored procedure returns the file information for the selected database e.g.
USE AdventureWorks;
GO
EXEC sp_helpfile;
GO
It will return the resultset similar to following
By default, this view returns a column called size but this is actually the size in 8KB pages therefore, to get the exact size in KB, as returned by sp_helpfile, multiply it by 8 as mentioned in above query.
