Question about Bulk Backup Storage

[Scharbag]

The company I work for uses HP SANs for our production environment. They are expensive but they work well it seems (not my job to manage). We also have some Synology UC3200 systems at some remote sites that suit our needs but they cannot expand to what we need for bulk backups.

We are looking for more cost effective bulk storage for backups as the HP gear is not really priced appropriately for this use. We currently have Fiber Channel tape backups as well as some spinning rust in QNAP etc. Our use case for bulk storage is for backups only. We use Veeam currently. We need compatibility with SAP and SQL backups.

Questions that I have is:

1. Is ZFS compatible with SQL and SAP (SAP points us towards BTRFS)
2. Would a TrueNAS M-Series system meet these needs?
   1. Initial repository expected to be ~1PB
   2. Needs to have fault tolerance
3. Should be expandable for future use
4. Prefer the ability synchronize with an off site repository (we have a sister site with a 2Gbps 60GHz link between us and them - initial sync would be done locally...)

I am a hobby TrueNAS guy. This is not my area of expertise. From the first glance at the M-Series gear, and my rudimentary knowledge of TrueNAS Core, it seems to be a possible solution. My first thought would be to share the bulk storage to Veeam over 10GE or 40E and just use TrueNAS for the bulk storage. Then, use ZFS replication to copy differentials to the remote site on a schedule. (Would be nice to have both sites replicate their data to each other - it is different data completely at both sites). There are probably better ways to do this, but this is why I am asking.

So, if there are any peeps on this forum that have M-Series devices in production, or other like type TrueNAS systems, please let me know your thoughts. We are at the very beginning of the journey and I would like to have some options to spur conversation.

Thank you!