In SSMS
-Right click / properties on the database
-In files section check the initial size and set it to a lower value
-Click Ok
Now the shrink file/database will work
I always appreciate an answer even if it's a bit late. Just so you know, your responding to a post that's over 9 years old. 😉
I know, but I find the post today with the same problem.
And was a little confused to see everybody telling "no you should not shrink database! Its bad ! gnagnagna " but without answering to the real question.
I think that it good for the comunity to share when a solution is found.
Bye
Yep... very much appreciated and that's why I said what I said. Also, you forgot one of the important parts for the solution. 😉