Back up the transaction log for the database to free up some log space.

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:

BACKUP LOG  WITH NO_LOG

Since you cannot continue to perform transaction log backup after this command has been executed, you should perform a database backup.