Skip to main content

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

I cannot log into the application due to the following error:- SERVERNAME: the transaction log for database FMAST12 is full due to LOG_BACKUP

Written by Jes
Updated over 3 months ago

Backup database from SQL management studio and then complete the following steps:

  1. right-click database name folder

  2. select properties

  3. options

  4. change 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

If this does not work, Please raise a new case online and reference the title of this article.

Did this answer your question?