Database Transaction Log and Update Large Number of Records

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'.

Solutions

• 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.