BE SQL Agent vs SQL dump (.bak)
We are planning on using be 2012 CASO and dedupe with replication to mms at second site to backup various servers including files, exchange and MS SQL.
We are discussing options with DBA team and they are not comfortable with the way BE agent backs up SQL databases. I am personally fairly open and believe that symantec wouldn't be in business if their sql backup weren't up to scratch. However, I am not DBA and therefore not in a position to argue either way.
We have a mixture of simple mode and roll forward. Our DBA team run backups dumping to .bak files. If we were to back these up, would dedupe work as well on these as would the be sql agent.
We don't mind a 2 stage backup/restore, this is really not important, what we want is a solution that is 100% viable and will keep everyone happy.
I wold like to know your thoughts / experience.