Full backups with differential of sql databases not performing properly
Posted on 2011-03-25
VMware 4.0, SQL 2008, Backup Exec 2010 R2
This is what is happening: I run my full backup of the sql database on Saturday morning. Right after that I backup the virtual machine (the vmdk file) which from what is happening is triggering again another full backup of the sql database. So when my differential runs on Monday I get 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.'
What it's boiled down to is the Backup Exec SQL agent does the full but then the VM causes a full too (I think) making the SQL agent think on Monday that something else has taken a backup. I have confirmed with the SQL guy that no other backups or maintenance plans are running on the database server. This also NEVER happened when I was using Backup Exec 12.5.
I could change the selection order in Backup Exec to have the SQL full backup go AFTER the VM is backed up but then it seems like overkill. Not sure what to do. I do have a ticket in with Symantec but we've been playing phone tag for a few days now so I'd see if anyone else had this problem.
P.S. What happened to the Backup Exec zone? Couldn't find it to add it.