SQL Server 獲取數據庫大小
實例代碼:
SELECT
DB_NAME(database_id) AS DatabaseName,
SUM(size) * 8 / 1024 AS TotalSizeMB
FROM
sys.master_files
WHERE
type = 0 AND DB_NAME(database_id)='BAI'-- 0 表示數據文件
GROUP BY
DB_NAME(database_id);

浙公網安備 33010602011771號