• Hi

    I had a similiar issue with an OLTP db on one of my servers, all the symptoms look to be the same. My suggestion is to investigate if the transactions within your log file are being committed or hardened to your data file. The problem I found was that across tran log backups the uncommitted transactions were remaining. The resolution was then to weekly run independantly a TRUNCATE LOG SQL Agent Job, ensuring that uncomitted transactions were rolled back.

    Regards,

    Ronan