BE2012 SQL Full backup without affecting other Incrementals
I am currently setting up BE2012 to backup our SQL 2008 cluster.
The Full backup each week and subsequent incremental backups seem to work fine to our tape library but we also need a daily full overwrite backup to disk so we can move to an offsite storage.
The problem i would have (i think) is will the incremental backups then compare to the daily full or the weekly full? Ideally i want them to compare to the weekly as those backups will be in the same place and we won't have to restore the offsite backup to restore the incremental for it.
One of the other issues that i forsee is that when i was initially setting the backup up, the incrementals kept failing due to SQL itself running its own backups and the incrementals knew that BE did not do the last full backup. The SQL backups had to be stopped for this to complete without errors.
Not sure if i have made this more confusing than it actually is...
Any help appreciated.