Get SQL server database size, location and volume info using DMVs April 23, 2018 SELECT * FROM sys.master_files AS f CROSS APPLY sys.dm_os_volume_stats(f.database_id, f.file_id) v; Read more