Unanswered: Can't shrink first file in PRIMARY group after EMPTYFILE
I ran a DBCC SHRINKFILE with the emptyfile option on the first file in the PRIMARY file group, and it seemed to work successfully. The used space now shows as < 1MB and appears to contain only the system objects. However, the free space was not released back to the OS. Subsequent tries to do a SHRINKFILE will not release the space either. I've been able to shrink the first file in the primary group before and have it release the space, but if i've used the emptyfile option on that file, it seems not to work after that. Any ideas?