Skip to Content
Product Information
Author's profile photo Laura Nevin

Spotlight: Table-level Backup & Restore (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?

The table-level backup feature allows you to back up and restore individual tables in a database in your data lake. Translated, table-level backup means you create an AES256-encrypted binary file of the data that is in the table.

You can even compress the backup if you want to save space in the object store of the corresponding infrastructure-as-a-service (IaaS) provider (e.g., Amazon AWS).

When and why do I need it?

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 decide to use this feature to bolster your disaster recovery plan (by integrating table-level backups into the strategy).

Finally, you could use this feature as a clever way to make your data exports more efficient (by moving data into the table(s) you are backing up before exporting).

How do I access this feature?

The table-level backup and restore capability is already enabled and ready for you, provided you are running SAP HANA Cloud, Data Lake version QRC01/2021 or later. While you will see an enableBackups parameter that enables the normal database backup capability in SAP HANA Cloud, Data Lake, the setting has no impact on this feature.

As you might expect, though, you’ll need the requisite object-level privileges on a table (or be the owner) to perform backup and restore operations on it, but the general ability to perform table-level backup and restore does not require special or separate permissions.

You will find the syntax to backup and restore a table fairly simple. The only tricky part will be ensuring that you know the connection string information for your IaaS provider (hyperscaler):


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

Where do I find more information?

~ end ~

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Mark Mumy
      Mark Mumy

      Laura Nevin Check out this blog that I put together on data lake schema exports.  It takes this new feature in HANA Cloud, data lake as well as IQ 16.1 SP05 and shows how to use it to accomplish a schema level extraction much like SAP HANA users are used to.

      Author's profile photo Laura Nevin
      Laura Nevin
      Blog Post Author

      Hi Mark, thanks for letting me know. Great post; I've added the link to my post as well.