Knowledge Base

Log backup failing because there is no current database backup

Category: Troubleshooting & error messages
Date: 07 Apr 2009
Product: SQL Backup
When performing 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 occurs when the database recovery model has been changed to Simple and/or the recovery model has been changed back to Full but a full backup has not been performed since the change. A full backup must be performed before restarting the backup job.

 If a full backup has been performed, the following conditions will require that another full backup be taken:

· The recovery model had been changed without taking a full backup
· A SQL maintenance plan task had changed the recovery model (reindexing can cause this)
· A backup specifying TRUNCATE_ONLY had been run on the database
· The database was detached from another server and attached to the current server