Hello Community,

Im having a really hard time getting the mssql database file shrinked to minimum available size that SSMS shows in GUI. I really need help and explanation because it’s not relevant on any tech forum I found about it.
My issue is that I want to shrink db data file and in GUI, the minimum size of the file is 2314MB.

I apply the shrink – it does nothing. The db file still remains the same and I can repeat the process forever and nothing will happen to file.
Im looking for a good explanation of this behaviour as tried lot of different methods found on the internet and I can’t make this shrink to happen.

Best regards, Paweł

​Hello Community,Im having a really hard time getting the mssql database file shrinked to minimum available size that SSMS shows in GUI. I really need help and explanation because it’s not relevant on any tech forum I found about it.My issue is that I want to shrink db data file and in GUI, the minimum size of the file is 2314MB.I apply the shrink – it does nothing. The db file still remains the same and I can repeat the process forever and nothing will happen to file.Im looking for a good explanation of this behaviour as tried lot of different methods found on the internet and I can’t make this shrink to happen.Best regards, Paweł  Read More

​