VM backup of SQL server breakes Log backup sequence
Here's my scenario:
Backup exec 2010 R3 SP3.
Everyday (inc. weekends) at 05:00 AM we're having a full backup of the databases of 6 SQL servers, and after that we do a log backup every 5 hours (one job with a selection list of all the DBs on all SQL server).
All SQL servers are on Windows 2003 except one which is on Windows 2008 (computer name: SQL9).
Every Friday at 15:00 I have a job that takes a VM backup of all those SQL. The job is defined to use AOFO with Microsoft Shadow Copy.
The Log backup on 13:00 is successful but the Log backup on 17:00 always fails to backup the DBs on SQL9, saying:
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
I tried to exclude SQL9 from this job and created a seperate job for him without the AOFO, but still same problem.
On the SQL server logs I see that the VM backup realy backed up all the DBs.
I don't understand why is happaning only with one SQL server and not with the rest? What is the difference between them?