Hi @Jay
Thanks for your question.
When the transaction log becomes full due to 'LOG_BACKUP'
Gnerally SQL Server Database Engine issues a 9002 error.
Please find below general recommendations when you are working with transaction log files issue. I hope those would be helpful to mitigate such issue.
Manage the size of the transaction log file
And Troubleshoot a Full Transaction Log (SQL Server Error 9002)
Referring to this similar thread: How to fix this 'The transaction log for database 'Search_Service_DB' is full due to 'LOG_BACKUP'.?
To avoid it in the future, you can use the methods below:
· Backing up the log.
· Freeing disk space so that the log can automatically grow.
· Moving the log file to a disk drive with sufficient space.
· Increasing the size of a log file.
· Adding a log file on a different disk.
· Completing or killing a long-running transaction.
Let us know if you have any question or need additional information.
Thank you!