SQL – The Log File Is Full

When backing up a a SQL database with Symantec Backup Exec I was seeing the error “The log file for database is full. Back up the transaction log for the database to free up some log space.” With backup exec to fix this you can run a backup of the SQL database and under the SQL options set the “Backup method for databases” to “LOG – Back Up Transaction Log.” However you can also clear this error by using the Microsoft SQL Query Analyzer and running the following query:

backup log db_name with truncate_only
go
dbcc shrinkfile (db_name_log,0)
go