I have a database in which I dropped several large tables. I would like to reclaim the unused space. The size of the database was 51gig. Then I backed up the database. The size of the database backup went from 41gig to 15gig. Then I restored the database from the new backup of 15gig. The database size did not change from it's original size. It was still 51gig.
When I run sp_spaceused, I get the following results:
database_name database_size unallocated space
Aspx2_DW 51703.25 MB 37062.80 MB
reserved data index_size unused
14948552 KB 13621488 KB 1307704 KB 19360 KB
I also ran dbcc updateusage (aspx2_dw) which did nothing. How can I reclaim the unused space?