Post reply

Temp DB FULL

  • June 10, 2008 at 1:46 am

    #124148

    Hi Friends

    My Production Server Temp DB Is full How can i shrinke that database any plz tel me step by steps

    T&R

    KU

  • June 10, 2008 at 2:57 am

    #826491

    There are a few ways to do this, but they either involve restarting SQL server or making sure that there is no activity happening on the tempdb database. This may be difficult on a production db and may require a scheduled outage.

    Check out this KB article.

    http://support.microsoft.com/kb/307487

  • June 10, 2008 at 3:03 am

    #826493

    Hi Could any body help me how i can solve this temp db in Production server

  • June 12, 2008 at 1:48 pm

    #828098

    See Steve's suggestion. Call an outage and restart the services/server. It'll rebuild tempdb. Can you determine what's filling it up (maintenance job? runaway query?) or are you dead in the water?

    -- You can't be late until you show up.

  • August 7, 2008 at 4:56 am

    #854349

    add additional file

  • August 7, 2008 at 5:16 am

    #854357

    truncate the Temp db & change the recovery model to simple

  • August 7, 2008 at 1:33 pm

    #854730

    dba_ch (8/7/2008)

    add additional file

    This will work only if it's added to a different physical drive that has space available....

    -- You can't be late until you show up.

  • August 7, 2008 at 1:37 pm

    #854733

    ch.mohni (8/7/2008)

    truncate the Temp db & change the recovery model to simple

    TempDB's recovery mode is always set to simple....

    -- Edit - The most important lesson to be taken from this thread is to find out what is causing it to grow. If it's normal business process, add more disk. If it's not normal, correct the problem. A lot of work takes place in TempDB and, as stated, if it fills up and cannot grow, the server will stop responding until you do something to correct the issue.

    -- You can't be late until you show up.

  • August 8, 2008 at 7:24 am

    #855147

    Exactly Said.. Tempdb cant be changed to any other recovery mode, it is always set to Simple.

    You could shrink the file or bounce the SQL Instance... 🙂

  • August 8, 2008 at 7:38 am

    #855170

    Kumar (8/8/2008)

    You could shrink the file or bounce the SQL Instance... 🙂

    If the file is full (no free space within) then shrinking the file (releasing free space within the file to the file system) is not going to do anything.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 10 posts - 1 through 9 (of 9 total)

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