SQL Backup 6

SQL Server error 4214 - BACKUP LOG cannot be performed because there is no current database backup

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.


Didn't find what you were looking for?