How to properly backup Enterprise Vault with agents
Since we got Enterprise Vault, backups have been a pain. I've really wanted to focus on getting them correct, and have spent the last few days making changes, doing test backups. Seems like when I fix one issue, another arises. So I need some help!
Here's the enviornment. I've got 2 Enterprise Vault servers, EV1 (pretty much does everything) and EV2 (only Discovery Accelerator) and both servers have their databases on SQL1 (only EV databases). All servers are virtual, and we have all the proper agents. Running EV 10.0.4 and BE 2012 SP3.
Typically we run daily incrimental backups, with fulls on Saturdays.
Problems that I am having are mostly with SQL backups. Either it complains that no transaction logs are backed up, or that some other application has already backed up the database, so changes are now out of sync. According to Symantec's best practice, all the databases of EV should be set to recovery mode Full. The EV Agent jobs don't allow me to tweak any SQL stuff. Theres no SQL section, so I have to do that elsewhere, but then I get the errors about something else backing up the databases.
I also have AVVI backups of these servers, but have learned that having them set to GRT backups will disrupt SQL backups, so I've got that turned off for the AVVI backup of SQL1.
Without getting too crazy detailed in the description with my backups - can someone give a suggestion here? I know backups without the EV agent are more painful, but EV agent backups should be easier than this!
Thanks in advance!