HiTry thisSELECT DB.name, SUM(CASE WHEN type = 0 THEN MF.size * 8 / 1024.0 /1024.0 ELSE 0 END) AS DataFileSizeGB, SUM(CASE WHEN type = 1 THEN MF.size * 8 / 1024.0 /1024.0 ELSE 0 END) AS LogFileSizeGBFROM sys.master_files MF JOIN sys.databases DB ON DB.database_id = MF.database_idWHERE DB.source_database_id is null -- exclude snapshotsGROUP BY DB.nameORDER BY DataFileSizeGB DESC
Hats of to a job well done. I really appreciate T SQL code that works. It works perfectly since Microsoft two methods do not work.