Sharepoint Daily Differentials not working in Backup Exec 2010

We run Symantec Backup Exec 2010 for our backups.  Most of the time this works fine and we have no issues.  However I've had a problem when Symantec Backup Exec trys to backup daily differential, it never works.  We get the following error..

2007SP Daily -- 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.

Now ok this would be an issue if the Weekly backup we run didn't work but they never fail, they are using the SQL Agent I need to know why the Differentials are not working and are always failing.  We have also tried to recreate the job for the Daily Differential but again no joy.

Any Ideas would be welcome...
lfrs_orgAsked:
Who is Participating?
 
honmapogConnect With a Mentor Commented:
You are most likely making backups of the SharePoint SQL databases with SQL server itself (probably in a maintenance plan), and not exclusively with Backup Exec.
Because SQL differentials cannot reliably be restored when you're making backups using 2 different methods (SQL itself and Backup Exec), Backup Exec throws an error.
The weekly backups have no problem, as they are probably full backups. Full backups can be restored without problems, no matter how many backup softwares you use. So Backup Exec doesn't fail those.

Make a choice. Use Backup Exec or SQL, to make the backups. But don't use both.
0
 
lfrs_orgAuthor Commented:
Thanks honmapog after further investigation we have found that we are doing a maintainence plan that is doing differential backups.

we are investigating if we need both...thank again
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.