Can you shrink the tempdb database size???

[sadcaper]

We had a process continually run that totally filled up the tempdb which had the option of increase size and no max file size. So now the file size is 16 gig. It's taking up the whole server. It says that only 10 mb are actually being used, so I should be able to shrink it, shouldn't I?

I tried to shrink it using Enterprise Manger and DBCC ShrinkDatabase. Nothing works. It just won't shrink it. It says that it has, but the numbers are still the same.

Is there anything I can do? What are my options here? We need that space on the server!!!

Thanks,
Drew

 

[tlbroadbent]

Shrinkdatabase should work. You can also try DBCC shrinkfile. If all else fails, stop and restart SQL Server. TempDB will be recreated with the default size. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[sadcaper]

Yeah, I tried the DBCC SHRINKFILE also, and that didn't change anything. Very weird. I thought maybe you just can't shrink tempdb. I tried it on a user created db, and it did work. It shrunk the database. So I dunno.

I'm gonna try to start and stop SQLServer and see if that works.

Thanks for the tip,
Drew