Backup and Restore
This section provides information to help you configure your SAP HANA database to work with Backint. It also provides information about the backup storage paths and guidelines to help you perform backup and restore operations.
Topics
Backup and restore your database - SQL statements
The following are examples of SQL statements that you can use to perform backup and recovery. For more details, refer to the SAP, SAP HANA Administration, or SQL Reference guides.
Perform a full backup
Use the following syntax to perform backups on a single-tenant instance or on a multi-tenant SYSTEMDB database.
_10BACKUP DATA USING BACKINT ('<BACKUP_PREFIX>')
Use the following syntax to perform backups for a Tenant database.
_10BACKUP DATA FOR <TENANT_DB_NAME> USING BACKINT ('<BACKUP_PREFIX>')
Perform a differential backup
Use the following syntax to perform backups for a Tenant database
_10BACKUP DATA DIFFERENTIAL FOR <TENANT_DB_NAME> USING BACKINT ('<BACKUP_PREFIX>')
Perform an incremental backup
Use the following syntax to perform backups for a Tenant database
_10BACKUP DATA INCREMENTAL FOR <TENANT_DB_NAME> USING BACKINT ('<BACKUP_PREFIX>')
Recover a database
-
Recover a Tenant database to a specific point in time:
_10RECOVER DATABASE FOR <TENANT_DB_NAME> UNTIL TIMESTAMP 'YYYY-MM-DD HH:MM:SS' USING CATALOG BACKINT CHECK ACCESS USING BACKINT -
Recover from a specific backup_id:
_10RECOVER DATA FOR <TENANT_DB_NAME> USING BACKUP_ID 1234567890123 USING CATALOG BACKINT USING DATA PATH ('/usr/sap/<SID>/SYS/global/hdb/backint/DB_<TENANT_DB_NAME>/') CLEAR LOG -
Recover your tenant database with a specific data backup without using a catalog.
_10RECOVER DATA FOR <TENANT_DB_NAME> USING BACKINT ('<BACKUP_PREFIX>') CLEAR LOG
Perform a system copy
Backint allows you to perform system copies by restoring a backup of a different database into the target database. Backint should be installed in the target database server and it should be able to access the Amazon S3 bucket where the backups of the source system are stored.
_10RECOVER DATA FOR <TARGET TENANT_DB> USING SOURCE '<SOURCE TENANT_DB>@<SOURCE HANA SID>' USING CATALOG BACKINT CLEAR LOG;
If you are performing a system copy across two different AWS accounts, ensure that you have the appropriate IAM permissions and Amazon S3 bucket policies in place. See the Identity and Access Management section in this document for details.
Backup and restore your database - SAP HANA Studio or Cockpit
In addition to using SQL statements, you can initiate the backup and recovery process from SAP HANA Cockpit or SAP HANA Studio. For more information, see Backup and Recovery and Reference: Backup Console (SAP HANA Studio) in the SAP documentation. Ensure that you are using the latest version of SAP HANA Cockpit or SAP HANA studio to get all of the latest features from SAP.
Scheduling and managing backups
You can use SAP HANA Cockpit to schedule periodic backups of your target SAP HANA database, including log backups. Ensure that you choose Backint as the backup type when scheduling your backup. For more details, see Schedule Backups in the SAP HANA Administration with SAP HANA Cockpit Guide.