Skip to main content

Error - 'SERVERNAME: the transaction log for database FMAST12 is full due to LOG_BACKUP'

This article explains an issue where login fails due to a database error stating that the transaction log for database FMAST12 is full because a log backup is required.

Written by Jes

Overview

You may not be able to log into the application due to the following error:-

SERVERNAME: The transaction log for database FMAST12 is full due to LOG_BACKUP. This will require you to firstly back up the database from SQL Management Studio.

I have backed up the database. What to do next?

If you have backed up the database from SQL Management Studio, please follow the steps below:

  1. right-click Database Name folder.

  2. select Properties.

  3. Click Options.

  4. Change the recovery model from Full to simple.

  5. right-click Database Name folder.

  6. Select Tasks.

  7. Shrink Files.

  8. file type: log, reorganise pages before releasing unused space: shrink file to: e.g. 100 MB

Need further help?

If this does not work, please contact support, providing a screenshot of the error you are seeing and the steps you have taken.

Did this answer your question?