[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 574
  • Last Modified:

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...
1 Solution
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.
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now