Quick post on how to check how much space is free in your sql data files.
SELECT a.FILEID, [FILE_SIZE_MB] = CONVERT(DECIMAL(12,2),ROUND(a.size/128.000,2)), [SPACE_USED_MB] = CONVERT(DECIMAL(12,2),ROUND(FILEPROPERTY(a.name,'SpaceUsed')/128.000,2)), [FREE_SPACE_MB] = CONVERT(DECIMAL(12,2),ROUND((a.size-FILEPROPERTY(a.name,'SpaceUsed'))/128.000,2)) , NAME = LEFT(a.NAME,30), FILENAME = LEFT(a.FILENAME,60) FROM dbo.sysfiles a
Sql Server Powershell 