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

  • GilaMonster (10/30/2012)


    The log is a circular file, SQL writes log records until it reaches the end of the file, then cycles round and starts reusing the file from the beginning.

    Managing Transaction Logs[/url]

    http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    If you want to see what's using the log, put some monitoring in place, don't shrink it and force it to grow again.

    I guess at the moment i wanted to know why can't i shrink my logfile, what is holding up. Any query that can tell me this?