Scheduling SQL Full Copy Backups
I'm sure this has been asked a million times, but I'm not having luck finding the answer. We're looking for one of two ways to schedule GRT backups of our SQL databases without affecting the sequence of backup tasks our DBA has defined in his maintenance plans. Our environment is Backup Exec 2012. The SQL server is virtualized and we have Apps and DB agent installed as well as the AVVI option.
The way I see it, there are two options:
1) Backup the VM using AVVI + GRT. Modify the pre-freeze.bat script to include the -copy flag in each of the calls to BeVSSRequestor.exe.
2) Backup the database(s) directly using the BE agent.
The problem with the AVVI copy option is that it doesn't seem to actually perform a true SQL Full-Copy backup. I can see this specifically if I interrogate the msdb..backupset table and review the LSN and is_copy_only fields for the two requestor records it adds (one for "NULL", which AVVI adds and another for "Backup Exec SQL Agent" which GRT adds). It appears the "NULL" requestor entry is set correctly as copy-only without affecting LSNs, but then the GRT function runs and steps all over the seqencing, so in this sense the "-copy" flag in the pre-freeze script is pretty meaningless...
Conversely, it seems I can only perform copy backups using the SQL agent directly through one-time/unscheduled backups? Really? There's no way to schedule copy backups like there was in BE2010???? Is there any trick around this?