SQL backups/VMware/Transaction logs

[Gammawolf]

Hi there, looking for some advise on the above topic. I'll briefly explain what's going on in the current environment:

Currently we've got Backup Exec 2010 that does a full back up of several SQL boxes every night. During the day it also backs up the transaction logs. This is Mon - Fri. The machine is virtual but the backups are treated as physical (ie with windows agents)

As a move to get this in line with everything else I want to get those SQL boxes backed up via vCenter as full VMs. Which isn't a problem in itself as we have BE 2014 doing this for everything else. My issue is does this mean I have to scrap the transaction logs during the day? I can't seem to think of a way to combine the two since the VM backup will leave the SQL database in an "on" state with renders laying the transaction log on top useless?

Any thoughts would be much appreciated!

 

[Gammawolf]

Thanks for the input all, i had a feeling i wouldn't be able to fully consolidate it like that. Was hoping maybe there might be something clever that could be done but i guess that would be too nice!

I'll have to just use both methods and backup the VM, then backup the DB's / transaction logs via the agent. Unfortunately with BE 2014 they only support backing up the entire VM, the DB's aren't big so it's not going to take to much more time. I was approaching it more from the end of a DR situation and trying to eliminate that extra recovery step