Home Forums SQL Server 2005 Administering Log file growing on principal server--log backups scheduled every 2 hrs. RE: Log file growing on principal server--log backups scheduled every 2 hrs.

  • February 3, 2013 at 11:43 am

    #1583735

    HarryG24 (2/1/2013)

    Thanks Gail. I increased the frequency of logbackups.

    I tried shrinking because, my log file size is 60 GB and a log backup releasing 90% of space.

    that was my prod DB and my disk left with only 500 MB space left.

    I thought of shrinking and release some gigs to OS to avoid any application interruption.

    The problem now i am facing is, though i have 90% unused space in the log , i could not shrink it.Not sure why.

    Please correct me if my approach is wrong.

    Thanks for your time!

    How big do the log files (the TRN files in the backups) end up being now that you're backing them up once per hour?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)