Home Forums SQL Server 2005 Administering Tempgb log - not able to shrink....none of the queries are helping RE: Tempgb log - not able to shrink....none of the queries are helping

  • October 30, 2012 at 1:38 pm

    #1554356

    GilaMonster (10/30/2012)

    TempDB is in simple recovery model, Backup log with truncate_only does nothing to a DB in simple recovery.

    When shrinking a log file, you can't shrink past the active portion of the log. If that's right at the end of the file, you'll need to wait until it cycles around to shrink the log.

    p.s. Why are you shrinking the log anyway?

    Thanks. What do u mean by " If that's right at the end of the file, you'll need to wait until it cycles around to shrink the log."

    I am curious to see that why is my tempdblog 40gb, basically my end goal is to find the process which is causing it to grow such big