How to check Database size using sql script
How to check Database size using sql script
Solution
SELECT sys.databases.name,
CONVERT(VARCHAR,SUM(size)*8/1024)+' MB' AS [Total disk space]
FROM sys.databases
JOIN sys.master_files
ON sys.databases.database_id=sys.master_files.database_id
GROUP BY sys.databases.name
ORDER BY sys.databases.name
SELECT
name,
size,
size * 8/1024 'Size (MB)',
max_size
FROM sys.master_files;
Caculate database size in ms sql server
Find db size in ms sql server
