first, I have to correct myselfe, I shoud have asked if SnapCenter can do file-based backups of HANA 1.0 MDC Multitenant.
I figured out that there is a difference at the sqlcli backup command string formed by snapcenter, depending on what type of hana resorce is created at SnapCenter Resource configuration:
chosing single container: the backup command looks like backup data using file ('SnapCenter_hostname_hana_sid_hostname_date_time') asynchronous
chosing multitenant database container: it looks like BACKUP DATA FOR SYSTEMDB USING FILE ('SC_SnapCenter_hostname_hana_sid_tenant_hostname_date_time') ASYNCHRONOUS COMMENT 'hostname_hana_sid_tenant_hostname_date_time'
the comment statement is not supported on hana 1.0, so the file-backup failed.
the same string executed in hana sqlcli (hana 2.0 MDC single tenant) works (also with the comment statement.
I still have some tests outstanding with hana 2.0 MDC multitenant.
So, as it looks now: it seems to be possible to me hat SnapCenter based fiel-backup of hana 2.0 mdc, multitenant will work.
For a file-based backup of a HANA single container, SnapCenter is executing a single SQL backup statement.
- Backup data using file ...
For a file-based backup of a HANA MDC single tenant system SnapCenter executes the backup of the SystemDB as well as the backup of the tenant DB using two SQL commands.
- Backup data for systemdb ...
- Backup data for <tenant name> ...
For a file-based backup of an MDC multiple tenant system, SnapCenter would need to execute the backup of the SystemDB as well as a backup for each tenant. This is not implemented in SnapCenter and therefore won't work.