Move-SPSite : The transaction log for database 'db name' is full due to 'LOG_BACKUP'.

Question

I'm trying to move a site collection between content DBs but I keep getting this error (subject).
No SQL jobs are happening (e.g. log back-up) and the relevant log file is set to be 2,097,152 MB (unlimited in old money) and the current size is 5122MB.

I shrank the log file for the hell of it but still no joy.

Any body know what the error is really saying?

Answer 1

Any body know what the error is really saying?

It's a clear error message, the log file of the database is full. If the database is in full-recovery mode, you have to frequently run log backups to release VLF = virtual log file. You can check it with this little query:

select name, log_reuse_wait_desc, recovery_model_desc
from sys.databases

Answer 2

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!