SELECT	
		db_name() [DB]
		,isnull(ds.name,'Not Applicable') as [FileGroup]
		,df.file_id
		,df.name as [FileName]
		,df.type_desc as [Type]
		,df.physical_name
		,convert(int,size/128.) [Size (MB)]
		,convert(int,FILEPROPERTY(df.name, 'SpaceUsed')/128.) [Used Space (MB)]
		,convert(int,size/128.0 - FILEPROPERTY(df.name, 'SpaceUsed') /128.) AS [Available Space (MB)]
		,df.state_desc as [Status]

	 ,case 
		when df.max_size=-1 then 'Unlimited'
		else convert(varchar(50),ceiling(df.max_size/128.)) 
	end as [Max Size (MB)]

	 ,case 
		when df.is_percent_growth=1 then convert(varchar(20),df.growth)+'%'
		else 
		convert(varchar(20),convert(int,df.growth/128.))+' MB' 
	end as [Growth]

	,df.is_read_only
	,df.is_media_read_only
	,df.is_sparse

	FROM sys.database_files df 
		left join sys.data_spaces ds on df.data_space_id=ds.data_space_id 
	order by df.file_id 

use [вашабаза]
go