Jess,

The transaction log is a record of all of the changes your've made to the database.

Do you run massive UPDATE commands on a table? These can very quickly fill the transaction log.

Your DBAs should create a scheduled job to periodically move them to a safe place between your backups of the database.

>The log file for database 'smartapp' is full. Back up the transaction log for the database to free up some log space.
>The manual says that we must do backup to free some log space but the drive where the transaction log resides have 60GB free space. We keep on doing the backup at least this day almost 5 times. Why? Why? Why?