SELECT DB_NAME(DATABASE_ID) AS DATABASENAME, NAME AS LOGICAL_NAME, PHYSICAL_NAME, FORMAT((SIZE * 8) / 1024 , 'N0') SIZE_MB FROM SYS.MASTER_FILES ORDER BY SIZE DESC