The log file for database is full. Back up the transaction log for the database to free up some log space

While dealing with sql server databases, you might encounter this error while trying to insert data into the database

"The log file for database is full. Back up the transaction log for the database to free up some log space."

As the error message specified you should backup the transaction log in order to free up some log space.

Here are 2 commands that you can use to do just that.

To empty it 

backup log <dbname> with truncate_only

To backup to some other disk

backup log <dbname> to disk='c:\somefile.bak'

Read more...