SQL Server - How to Get Database Size in SQL Server 2008

To get database size in SQL server we need to write the query like as shown below

SELECT

database_name = DB_NAME(database_id)

, log_size_mb = CAST(SUM(CASE WHEN type_desc = 'LOG' THEN size END) * 8. / 1024 AS DECIMAL(8,2))

, row_size_mb = CAST(SUM(CASE WHEN type_desc = 'ROWS' THEN size END) * 8. / 1024 ASDECIMAL(8,2))

, total_size_mb = CAST(SUM(size) * 8. / 1024 AS DECIMAL(8,2))

FROM sys.master_files WITH(NOWAIT)

WHERE DB_NAME(database_id) = 'master' –-- your database name

GROUP BY database_id

Once we run above code we will get output like as shown below