| Below are some method or query to get database size with log files and without log files:-
(1)To get database size including log file
exec sp_spaceused
(2)To get number of rows in the table and space used for this table
exec sp_spaceused "MyTable"
(3)To get actual size of the database file and log file separately
select * from sysfiles | | |