BE SQL database
We are going to have 2 BE servers (1 CASO - 1 MMS)
One of the servers will be running backups with dedupe and replication to mms dedupe storage to another site.
The idea will be to have resilience in a way that if one of the sites go down, we can still backup / restore with the data that will be replicated.
I understand that we need to have SQL running (either Express or full blown, either on the backup server or a dedicated server) for the Backup Exec database.
How does that work in case of DR? or if we lose the SQL server? Do we need to rebuild a SQL server then restore db from backups? Do we need to mirror the SQL server?
I have read various articles on how to backup BE including this https://www-secure.symantec.com/connect/blogs/how-protect-backup-exec-itself but I am not sure they apply to CASO