tempdb

• kbrautig

  SSC Enthusiast

  Points: 169

  August 31, 2001 at 1:33 pm

  #157990

  The question I have is how to shrink a tempdb that is taking up about 5.3 gb of space on my server. I have attempted the shrink db function and it is not working. I have also stopped and started services and rebooted the entire server, but the space is still taken by tempdb. Any other thoughts?

• ckempste

  SSCoach

  Points: 17983

  September 1, 2001 at 9:04 pm

  #417922

  Hi there

  Did you try:

  dbcc shrinkfile

  dbcc shrinkdatabase

  I did this the other day and all worked a treat.

  Cheers

  Chris

  
  Chris Kempster
  www.chriskempster.com
  Author of "SQL Server Backup, Recovery & Troubleshooting"
  Author of "SQL Server 2k for the Oracle DBA"

• patilds

  SSChasing Mays

  Points: 615

  September 2, 2001 at 10:31 pm

  #417931

  Try

  DBCC SHRINKDATABASE (tempdb,10)

  This will decrease the size of the files in the tempdb database to allow 10 percent free space in the files of tempdb

  Deepak