Post reply

what to do when tran log fills up

  • April 30, 2007 at 5:15 am

    #119844

    what is the best course of action when the tran log fills up? should you back it up,  or truncate it using the dbcc command

    DBCC SHRINKFILE (dweocprogops_LOG, 7);

     

     

  • May 1, 2007 at 7:27 am

    #703528

    You should back it up.  If you use shrinkfile - you are just shrinking the size of a file that could possibly become filled up again and thus putting yourself into the same vicious cycle.

    Have a good day,

    Norene Malaney

  • May 6, 2007 at 3:43 am

    #704530

    Yes, as Norene said, you should backup the Tlog.

    When you want to shrink the Tlog file? : If the TLog file occupying more physical space on the drive also you want to free up some on the drive for OS, that time you can go for shrinkfile option. Otherwise not required. When you taking the Tlog backup, the commited transactions in the Tlog will be flushed and free up the pages for new logs.

    Hope this give you more clarity...

    Thanks
    Jay
    http://www.sqldbops.com

  • May 6, 2007 at 5:27 pm

    #704549

    How to stop the transaction log of a SQL Server database from growing unexpectedly

    http://support.microsoft.com/default.aspx/kb/873235

    A transaction log grows unexpectedly or becomes full on a computer that is running SQL Server

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

    MohammedU
    Microsoft SQL Server MVP

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

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