Check all drive space on the server

SELECT fixed_drive_path
	,drive_type_desc
	,CONVERT(DECIMAL(18, 2), free_space_in_bytes / 1073741824.0) AS [Available Space (GB)]
FROM sys.dm_os_enumerate_fixed_drives WITH (NOLOCK)
OPTION (RECOMPILE);

OR

xp_fixeddrives

dm_os_enumerate_fixed_drives

Spread the love