Backing up log and data files

During the setup procedure, the SAP HANA configuration is adjusted to use the BACKINT for SAP HANA window to back up the redo logs. SAP HANA regularly backs up the redo logs to the IBM Storage Protectâ„¢.

About this task

The frequency of backups can be adjusted with the SAP HANA configuration parameter log_backup_timeout_s that is stored in the persistence section of the global.ini  file. For more information about how to adjust this parameter, see the SAP HANA documentation.

Procedure

  1. In the SAP HANA Studio, select the database instance to be backed up.
  2. Right-click the database, and select Back Up.
    Alternatively, in the Specify Backup Settings window, select Backint for the destination type.
  3. Optional: On the command line, use the SAP HANA SQL client hdbsql.
    For example, the following sample connects to the instance with number 53, on host vhana06, as user system with password manager and runs a complete database backup:
    hdbsql -i 53 -n vhana06 -u system -p manager backup data using backint (DAILY)