Home Forums SQL Server 2005 Administering why i can't shrink tempdb data file RE: why i can't shrink tempdb data file
ganci.mark
Hall of Fame
Points: 3533
More actions
May 18, 2009 at 6:15 am
#996251
In my case it was a one time query that caused the tempdb files to grow so I did want to reclaim the 19GB that they were holding. I restarted SQL server and they cleared as expected.
There should be a way to do it with restarting.