[When you are using the simple recovery model you still need to backup the log.

Example:

backup log "dbname" with no_log

quote:

---

On our production database, we have setup our Recovery Model to "Simple". But transaction log is expending in MB's and takes up...