I have the following senerio...

I backup up a database and restored it to a new name. Ran some SQL against this restored database to drop all but one table. And all but 3 columns from the remaining table. When first restored the DB size was 59 Gig. After dropping and doing a DBCC ShrinkDatabase the size went to 34 Gig.
The column that was left was and Identity (int), GUID (uniqueidentifier) and a document (Varbinary).

In the original database I drop the document column for the same table. After doing a DBCC Shrink Database there is no change in DB size. There appears to be approx 4% free space in the database after the column drop. How do I go about reclaiming space after the drop.

I would think that I should be able to reclaim at least 30 Gig of space.

Thanks
Gary