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

Jay 21 Reputation points
2023-06-21T07:29:07.6866667+00:00

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?

Microsoft 365 and Office | SharePoint | For business | Windows
Windows for business | Windows Server | User experience | PowerShell
SQL Server | Other
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 47,436 Reputation points
    2023-06-21T07:57:26.15+00:00

    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
    
    
    0 comments No comments

  2. RahulRandive 10,486 Reputation points Volunteer Moderator
    2023-06-21T10:13:26.4333333+00:00

    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!

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.