Sharepoint Daily Differentials not working in Backup Exec 2010

Posted on 2011-10-07
Last Modified: 2012-05-12
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...
Question by:lfrs_org
    LVL 28

    Accepted 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.

    Author Closing Comment

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
    The viewer will learn how to install the Spideroak software to backup files. Start your default browser: In the URL location bar type and press enter: When you see the spideroak site, click the “Try for free” button in the upper ri…
    The viewer will learn how to download, install and use CrashPlan from on Windows 7. Open your browser and go to Click get started, it’s free then Click the Download CrashPlan button: Click save in Internet Explorer, the…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now