Use management studio and run it in new query window. You need sysadmin or atleast a view definition permission.
Addditionally you can add this in your query shortcuts as I have done.
It will give two result sets, first one with all the drives used by sql server files and available free space. second one with database file size in size descending.
Select volume_mount_point,max(vs.total_bytes) /1024.0/1024/1024 TotalSpaceGB ,min(available_bytes)/1024.0/1024/1024 FreespaceGB ,Count(*) as DBFileCount from sys.master_files S cross apply Sys.dm_os_volume_stats(s.database_id,s.file_id) vs Group by volume_mount_point Go Select physical_name,name, db_name(database_id) DBName,size*8.0/1024 SizeMB, Name from sys.master_files order by size Desc Go
This script shows size information of every database on the instance.
2013-08-21 (first published: 2010-07-26)
5,917 reads
2009-02-16 (first published: 2009-02-03)
2,618 reads
This script is used for SQL Server 2000 Database file remaining growth. This script is little bit modified to fit SQL Server 2000.
2009-01-14 (first published: 2009-01-03)
1,226 reads
Scripts will display size of the data in the database/data files and remaining allocated space.
2013-05-10 (first published: 2008-11-17)
3,744 reads
A better way to use sp_spaceused, returning values on one row for the database instead of two.
2008-09-04
4,044 reads
