tempdb

  • kbrautig

    SSC Enthusiast

    Points: 169

    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

    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

    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

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply