SQL Server error 4214 - BACKUP LOG cannot be performed because there is no current database backup
Published 22 November 2018
When attempting a log backup of a database, the following error may occur:
BACKUP LOG cannot be performed because there is no current database backup.
This error may occur if:
- The recovery model of the database has been changed to Simple.
- The recovery model of the database has been changed to Full, but no backup has been performed since the change.
- A job using
BACKUP LOGS [*]has run when a full backup does not exist for one or more databases on the server.
This may occur if you have added a database to the server since setting up the job. For more information, see Backing up all databases on an instance.
To resolve this problem, perform a full backup on the database in question.
