Skip to Content
Product Information

Spotlight: Backing up tables in SAP HANA Cloud, Data Lake

As of QRC01/2021, SAP HANA Cloud, Data Lake allows you to perform backup and restore operations on individual tables in your data lake.

What is this feature, and why do I need it?

The table-level backup feature allows you to back up individual tables in a database. In SAP HANA Cloud, Data Lake, this means you create an AES256-encrypted binary file of the data that is in the table you specify. You can specify to compress the backup if you need to save space in the object store of the corresponding infrastructure-as-a-service (IaaS) provider (e.g., Amazon AWS).

Choose to implement table-level backups when your database is very large and backing it up takes a long time or when you just want more frequent backups of critical data.

You might also integrate table-level backups into your disaster recovery plan.

Finally, you might also use table-level backup as a clever way to make your data exports more efficient by moving data into the table(s) you are backing up.

How do I access this feature?

You need to be running QRC 01/2021 or later SAP HANA Cloud, Data Lake to enjoy this capability. Of course, you’ll also need the required privileges to perform the backup or restore operation for the desired tables.

While there *is* an enableBackups parameter that enables the normal database backup capability in SAP HANA Cloud, Data Lake, you won’t need it for this feature. Table-level backup works regardless of the setting for this parameter.

The syntax to backup and restore a table is fairly straightforward, although you’ll need to know the relevant connection string information for your IaaS provider:

BACKUP%20TABLE%20and%20RESTORE%20TABLE%20statement%20syntax%20in%20SAP%20HANA%20Cloud%2C%20Data%20Lake

BACKUP TABLE and RESTORE TABLE statement syntax in SAP HANA Cloud, Data Lake

Where do I find more information?

 

/
BACKUP%20TABLE%20and%20RESTORE%20TABLE%20statement%20syntax%20in%20SAP%20HANA%20Cloud%2C%20Data%20Lake
Be the first to leave a comment
You must be Logged on to comment or reply to a post.