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.

  • 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!