Post reply

Will Transactional Log Backups slow the growth of Database Log file

  • July 17, 2013 at 12:32 am

    #295558

    Could somebody please clear up the confusion I'm having.

    Is it correct to say that if I do transactional log backups it will reduce or slow the rate of growth of the Database log file(.ldf), whereby shrinking the database log file will not be needed as this causes disk defragmentation if carried out for a long time....

    Problem is I have huge Database Log files(.ldf) which adds up after few weeks/months causing me to run out of disk space...

  • July 17, 2013 at 1:50 am

    #1633115

    Please read through this - Managing Transaction Logs[/url]

    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

  • July 17, 2013 at 5:06 am

    #1633174

    The shortest possible answer is, yes.

    But that doesn't take into account that you're clearly not clear on what exactly the transaction log is, what it's doing and why it's doing it. Read the book that Gail has referenced. It should give you the fundamentals you need to understand why 'yes' is the right answer, but totally incomplete.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • July 17, 2013 at 6:27 am

    #1633220

    Thanks will do, browsed through the document very informative.

    Will read through everything.

    Do understand what it is though probably phrased my ques incorrect.

    Thanks again

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

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