Backing up SQL Server using Full/Differentials - BackUp Exec 2010

[leeweedon]

We have BackUp Exec 2010 R3 5024 (32-bit) and are currently trying to backup 3 SQL servers.

SVR86 - This is SQL2008 that also has a SQL2005 Instance

SVR03 - This is our SQL2005

SVR35 - This is our SQL 2003 Server

the job has been configured in a policy, which has 2 backup jobs. 

FULL Backup - Complete FULL backup of all 3 servers

DIFF Backup - Complete DIFFERENTIAL backup of all 3 servers.

The full backup runs every sunday and completes without error, (or at most 3-4 exceptions)

The daily diff job, fails, with the following error..

Job ended: 04 July 2011 at 21:25:39
Completed status: Failed
Final error: 0xe0000363 - 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.
Final error category: Resource Errors

For additional information regarding this error refer to link V-79-57344-867
 

I have attached the Job log.

I have 3 SQL Agents installed on the server, as well as 3 remote agents. The latest agent is installed on all the SQL Servers and BKExec is at the latest update.

Any ideas?

[RahulG]

Make sure you are backing up the Sql database with just using backup exec and there is no other backup appication backing up your SQL databases. Also make sure you dont have any backup job configured withing Sql itself which is conflicting with the BE backup job.

refer http://www.symantec.com/business/support/index?page=content&id=TECH58674

[Colin_Weaver]

As well as are you backing up SQL  using SQL Dumps or other backup applications, are you doing log shipping or any other mechanism that might be recorded by SQL as a backup?

Also are yoru SQL server vritualized and are you therefor doing AVVI or Hyper-V snapshot backups of the virtual environment as well as you SQL backups?

[leeweedon]

Ok, problem was cause by the SQL Maintenance Jobs we do hourly. This give us the ability to restore to the hour.

As currently we don't have the architecture for SQL GRT back ups to disk on the hour we hav had to change are daily backup to full and disable the transaction log backups. 

Any ideas or ways on getting the two backups to work together ? 

What is the best way / schedulle to backup SQL Server using BK Exec?

[JohnnyLeung]

I also got problem on differentail backup for MS SQL database wtih similar erorr, anyone can help to solve this problem? Thanks.