Operation with a SQL Server database fail in Plesk: The transaction log for database 'example_db' is full due to 'LOG_BACKUP'.

Symptoms

• A Plesk backup task finishes with the following warning message:

  PLESK_WARN: Warning: Unable to back up database content. ["The transaction log for database 'example_db' is full."]

• The following error message:

  PLESK_ERROR: [SQL Server]The transaction log for database 'example_db' is full due to 'LOG_BACKUP'.

  is shown in Plesk when:

  • changing the maximum log file size of a SQL Server database
  • changing a database user login or password
  • exporting a database dump
  • suspending a subscription

Cause

The transaction log has reached its configured size or the disk does not have sufficient space.

Resolution

Truncate the transaction log:

1. Connect to your Plesk server via RDP.

2. Start SQL Server Management Studio (SSMS) at Windows Start > All Programs > Microsoft SQL Server Tools XX.

   Note: If SSMS is not installed, download it from the official Microsoft website and install.

3. In SSMS, connect to the database server where the affected database is located.

4. On the General page, set Backup type to Transaction Log.

    

    

5. On the Media Options page, selected Truncate the transaction log and click OK.