Job completed with exceptions -- How do you include SQL transaction logs in the backup using Backup Exec 2012?
I client of mine is using Backup Exec 2012. Their backups are completing successfully (for the most part, some intermittent failures), but they receive the following message after each backup:
The job completed successfully. However, the following conditions were encountered: Job Completed with Exceptions
We never received this message when we originally installed the product. These messages began maybe 6 months later. I originally thought the 'Exceptions' indicated that not all drives/folders/files were included in the backup, but i have come to find out that the 'Exceptions' are actually the SQL transaction logs that are not being included.
We used to have it set up to run a full backup once a week and incremental backups for the other days. The incremental backups were failing consistently stating:
The job failed with the following error: The Backup Exec SQL Agent was not used to create the last full, differential, or log backup of this database. You must use the SQL Agent to run a full backup before you can run a differential backup or transaction log backup.
**Note** -- even though they receive the failure notification, when I check the backup destination, I see backup files that were being produced daily. We have since swithced over to full backups daily to get rid of the failures, but still receive the 'exceptions'.
From what I read online, the full backup should automatically include the SQL transaction logs (the SQL instances are selected as part of the backup). So, here are my questions:
1. Are the SQL transaction logs automatically included in a full backup?
2. If so, Why do the incremental backups keep failing with the message given above?
3. If not, How do I use the Backup Exec SQL Agent to run the full backup? I have not seen anything resembling it in the user interface.
Thank you for reading this, and any help is appreciated!