tempdb won't shrink

[ianicr]

I noticed my tempdb is 2 gigs earlier. This seems a little large to me. I did a bit of googling and came up with this:

use tempdb
backup log tempdb with NO_LOG
dbcc shrinkfile (templog,0)
dbcc shrinkfile (tempdev,0)

however this doesn't shrink the data file only the log. Any ideas why? or how I can shrink it?

Thanks

 

[JayKusch]

Try stopping and restarting SQL Server

Thanks

J. Kusch

 

[SQLBill]

You also CAN NOT shrink any database smaller than the size of the MODEL database. You are trying to shrink the TEMPDB to 0 and that can't be done. Check the size of the MODEL db and then try running the DBCC SHRINKFILE with that number.

BTW the syntax is DBCC SHRINKFILE (file_name, target_size)
and target_size must be an INTEGER in megabytes.

-SQLBill