These pages cover SQL Backup Pro 8.0. Help for older versions is also available.

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.

  • No labels

Visit the Redgate forums

Contact support

Mistake on this page? Email us