I had a table which was 100 gb and whole database size was 150 GB.
I have archived that table to another server and dropped the table from the existing server and freed 100 GB space but i am unable to shrink my database as it is giving me the below error:-
File ID 1 of database ID 7 was skipped because the file does not have enough free space to reclaim.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
sp_spaceused output is as follows::
database_name Database Size unallocated space
test 157449.31 MB 113945.80 MB