Here is a quick query to identify your db status when it comes to disk space:SELECT ds.name as filegroupname, df.name AS 'FileName' , physical_name AS 'PhysicalDBName', size/128 AS 'SizeInMB', size/128.0 - CAST(FILEPROPERTY(df.name, 'SpaceUsed') AS int)/128.0 AS 'RemainingSpaceInMB' , CAST(FILEPROPERTY(df.name, 'SpaceUsed') AS int)/128.0 AS 'SpaceUsedInMB', ......