I have a customer server with SQL Server 2008 R2 Express. It contains a lot of small databases (only around 2-10 MB each) except for the msdbdata.mdf. The size of that database is over 10GB and i now only have 189MB of free space left on C: so I have to shrink this database imeatitly.
My question is if the SQL-server vill create some kind of temporary file that will grow when I use the shrink command from management studio? If yes, can i in some way have this temporary file be created on a different partition?