46Gb Tempdb does not want to shrink!

• dries bessels

  Grasshopper

  Points: 11

  More actions

  March 23, 2006 at 5:07 am

  #189918

  Hi All,

  somehow we have been lumbered with a 46Gb Tempdb. I am not sure how this happened but first priorityu is to get it down without rebooting the server. I have tried all sorts of ways of shrinking files but they do not seem to want to work, even though there is only about 112 Kb used.

  Any hints or tips are welcome!

  Thanks!

  Dries

• mrbran03

  SSC Rookie

  Points: 28

  More actions

  March 24, 2006 at 5:40 am

  #628573

  If its not set to "simple" recovery mode already, try setting the tempDB to that and then try the shrink again.

• SQLHAWK

  Right there with Babe

  Points: 716

  More actions

  March 24, 2006 at 7:40 am

  #628618

  Make sure to kill any transactions using TEMPDB or wait until they're finished.

  Then run this:

   use TEMPDB

    dbcc shrinkfile (TEMPDEV, 1000)