Error: Back up the transaction log for the database to free up some log space.
To recover from a full transaction log
If the log is 100% full you cannot truncate it by backing it up, since the backup has to be recorded in the transaction log. For version 6.5, use:
DUMP TRANSACTION dbName WITH NO_LOG
And for version 7 or later:
Since you cannot continue to perform transaction log backup after this command has been executed, you should perform a database backup.