Home Forums SQL Server 2005 Administering Transaction log files had grown to five times the database size. RE: Transaction log files had grown to five times the database size.

  • it's not single transaction file. But in period of time the log file is going on increasing.

    My concern is even after backup strategy i need to shrink the file monthly twice which i won't want to do very regularly.

    As said if it increasing for single transaction then it would better option to resize the log file.

    So need your help where i can set any option where the log file will re-use the inactive portions. so that i will not run any shrink cmmd.

    -Sanath