topic SnapCenter file-based backup for SAP HANA MDC with multiple tenants in Data Protection

SnapCenter file-based backup for SAP HANA MDC with multiple tenants

Spaceball — Wed, 04 Jun 2025 13:01:10 GMT

Hi,

As "Snapshot backup of HANA 2.x MDC with multiple tenant" is not supported by SAP now, I'd like to know if

at least the "file-based backup of HANA MDC with multiple tenants" is possible with SnapCenter....

Re: SnapCenter file-based backup for SAP HANA MDC with multiple tenants

Nils_Bauer — Fri, 14 Dec 2018 13:39:07 GMT

No, SnapCenter can't execute file-based backups for SAP HANA MDC multiple tenant systems.

Re: SnapCenter file-based backup for SAP HANA MDC with multiple tenants

Spaceball — Fri, 14 Dec 2018 14:48:26 GMT

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.

I'll keep you updated.

Re: SnapCenter file-based backup for SAP HANA MDC with multiple tenants

Nils_Bauer — Fri, 14 Dec 2018 15:01:09 GMT

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.