Post reply

how to control LDF file growing size?

  • February 12, 2015 at 12:24 am

    #294616

    Hi.

    Generally shrinking Transaction log file is not recommended and it is not best practices also.

    One of the OLTP live database transactional LDF file growing like anything and growing per day is 10GB. Even I have planned and configured to take transactional log backup at every 30 min by using management plan.

    Could anyone give me best solution for control that LDF file growing? Or To be changed TRN backup frequency to 15 min from 30 min.

    rgds

    ananda

  • February 12, 2015 at 4:14 am

    #1777174

    Start by figuring out why it's growing. Search for my article "Help, my transaction log is full."

    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

Viewing 2 posts - 1 through 1 (of 1 total)

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