I have a DB that is currently set to a SIMPLE recovery model. I thought the log should truncate at 70% but it keeps on filling up. Anything I am missing?
Only committed, i.e. completed transactions are dropped from the log. Uncommitted transactions cannot be dropped. Check to see if your SQL code is leaving open transactions.