How can I recover space from my data files?

[jonmohr]

I have 2 databases that have a lot of free space to them after running the Shrink Database task by right clicking on the DB and selecting All Tasks > Shrink Database.

Now, after looking at the properties of one of the db's I see
Space Available = 11709 MB
Size of the DB = 11792 MB

However, what I was hoping would happen is to be able to recover that free space in Windows, which did not happen. How can I reacquire the free space that is being used for the db that obviously isn't necessary?

Thanks!

 

[yelworcm]

Enterprise Mangler, unfortunately, does not do a very good job at reporting the actual facts. See what you get from

sp_spaceused @updateusage = 'TRUE'

 

[mrdenny]

You should also do the DBCC command from Query Analyzer. It will output some useful info when you run it if it can't shrink the file.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com