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?