Bob Shaw (6/2/2009)

---

Im trying to perform a transaction log backup to the same *.bak file holding the Full Database Backup. Im getting this error "BACKUP LOG cannot be performed because there is no current database backup."

I opened the backup file to view its contents and the the database is in there as a FULL backup.

When the database backups run it's marking the expiration date as 7 days from the execution date. I'm also backing up the master and msdb in the same backup file.

The backup order goes like this:
1. master (full backup)
2. msdb (full backup)
3. Our Application Database. ( full backup unless the database name is found in the backup file then it uses a Transaction Log Back instead)

Anyone else run into this situation? Is it possible to store a FULL and Transaction Log backup in the same Backup File?

David Webb (6/4/2009)

---

Is there a chance that the full backup procedure does an explicit truncate on the log at some point after the backup is taken? It would invalidate the use of the full backup as a staring point for rolling forward with the logs. Not a very likely scenario, but it's the only thing I can think of that might explain the problem.