In my database, I have few temp tables that total up to 50GB in size. I already removed the data from the table. When I set the shrinkdatabase in my maintenance plan, it runs successfully but doesn't shrink the database.
I tried dbcc shrinkfile(1,truncateonly) and got the same result.
However, from sql management studio when I right click the database and select shrink database, it takes a while and shrinks the database. I notice the file size reduces by 50GB.
my question is why it's not doing this with the maintenance plan shrink option or with the sql command?
Is there any other command that I could use to shrink it?
Appreciate any help on this.