An issue arose where a database was giving the error:
Could not allocate space for object ‘object-name’ in database ‘dbname’ because the ‘PRIMARY’ filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Today I ran a script to delete a huge portion of data in a DEV environment and I was excited to get back a few hundred GB, but I only got back a portion of the free space that the Properties window said I had. What was going on?
It turns out that when shrinking a database, the smallest a file will get is back to the “Initial Size” in the database properties/files window.
To shrink it more, simply lower the Initial Size and then shrink the database again. You can use the GUI or use: