Pages

Sunday 2 February 2014

How to Get Database Size in SQL Server 2008

How to Get Database Size in SQL Server 2008 /



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 AS DECIMAL(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


Demo:






No comments:

Post a Comment