We have a SQL Server installed. We have a 500GB drive for the database. Currently, we have 95 GB free on this drive. When I go into the database, and look at the Shrink File toolset, it shows the database at 410000 MB and the Available Free Space at 4500 MB, but the drive itself has 95 GB free. The files are set to 64MB Auto growth with a max size of Unlimited.
I take a backup of the files, then run DBCC SHRINKFILE() commands, but nothing is freed up. The size of the database makes sense at 400GB with 95GB free, but why does the DB think there is no available space and how do I fix this?