• If you do backup the transaction log, maybe you have another job running in a maintenance plan. Look to see if you are running DBCC DBREINDEX regularly under the Optimisation tab of the maintenance plan. The job is:

    Reorganize data and index pages. This can significantly grow the transaction log especially if you have 100% fill factor on your indexes.


    ------------------------------
    The Users are always right - when I'm not wrong!