sql-server find database file size on disk

علی ذوالفقار
1402/12/21 10:33:23 (161)
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         
Back