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.
Last modified: June 9, 2021

Author

Comments

Write a Reply or Comment