To get dB size with Path for each dBs on server.

SELECT d.name,

ROUND(SUM(mf.size) * 8 / 1024, 0) Size_MBs,

PHYSICAL_NAME

FROM master.sys.master_files mf

INNER JOIN master.sys.databases d ON d.database_id = mf.database_id

WHERE mf.database_id > 4...