Getting this error during updating a large number of records to a large table.
The transaction log for database 'XXXXXX' is full due to 'LOG_BACKUP'.
- Put the database recovery mode from “Full” to “Simple” to avoid generating transaction logs in the Full recovery mode.
- Update in batches.
- Update multiple columns at a time.