Post reply

TEMPDB - How Do You Truncate/Re-initialize?

  • April 2, 2004 at 7:29 am

    #84860

    Hi,

    Environment: SQL 7 w/SP2; Production database

    My tempdb grew from 300 mb to 13 Gb one night!! What are some ways to shrink this down to reclaim disk space? Also, is there any way to tell what is in this database that is making it so large? 

    Many thanks. Jeff

  • April 2, 2004 at 7:40 am

    #501609

    DBCC SQLPERF ( LOGSPACE ) 

    find out how empty it is.

  • April 2, 2004 at 7:54 am

    #501614

    It will be recreated smaller at the next restart of SQL.  Not always easy/possible with Production.


    KlK

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

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