Get SQL server database size, location and volume info using DMVs

,

SELECT * FROM sys.master_files AS f 
CROSS APPLY sys.dm_os_volume_stats(f.database_id, f.file_id) v; 

Rate

Share

Share

Rate