Database refuse to releast it's bloeted space to NTFS
My mdf file showa 600mb even after I try to scrink it. How do I scrink the database. I am expecting the "mdf" size to be under 100mb with the command below.
dbcc shrinkfile (shop_data,76800)
--DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
--494 1 76744 128 76736 76736