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

J
Written by Jes Foxall-Beckley
Updated over 2 weeks 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?