T-SQL Query to get data and log size in SQL Server
MSSQL SQL on Linux, SQL Server database sizeBelow query can be used to get database data and log size details in SQL Server.
SELECT
db.name,
sum(case when [type] = 0 then mf.size * 8 / 1024 else 0 end) as DataFileSizeMB,
sum(case when [type] = 1 then mf.size * 8 / 1024 else 0 end) as LogFileSizeMB
from
sys.master_files mf
join sys.databases db on db.database_id = mf.database_id
where db.name not in('master','model','tempdb','msdb') -- exclude system databases
group by db.name
order by DataFileSizeMB desc
Output:
