Video Screencast Help

Job completed with exceptions -- How do you include SQL transaction logs in the backup using Backup Exec 2012?

Created: 06 May 2014 • Updated: 07 May 2014 | 6 comments
This issue has been solved. See solution.

Hello,

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!

 

 

Operating Systems:

Comments 6 CommentsJump to latest comment

Jarzamendia's picture

Hi dude,

I have the same issue. Try check if a DBA in your client's site are doing a backup with the SQL tools. If this is true, try mark the option "Copy only" in the SQL backup job (of SQL tool). 

The Transition logs are no include in the full backup. You need use the incremental job to backup and trunk the log file.

If your database does not keep transition logs set up a differential job to backup your data.

grimleyi's picture

Thank to all for the suggestions. I will try them out next time I am on site (next 2-3 days) and then I will update the post.

 

grimleyi's picture

Hi,

The SQL transaction log is now successfully backed up! Thank you pkh!

Now to wait and see if the regular backups give a 100% successful without exceptions.