Deleting Backup Catalog objects

Edit online

To reduce the size of the SAP HANA Backup Catalog and optimize performance, you can periodically delete older backup objects for backups that were already expired in Data Protection for SAP HANA. Alternatively, you can configure the retention settings in SAP HANA Cockpit to automatically delete Backup Catalog objects, including the database backups from IBM Storage™ Protect Server.

Before you begin

Set the Retention Policy Scheduler to Yes or No, depending on whether you are applying retention settings to the Backup Catalog AND IBM Storage Protect Server, or if you are cleaning up the objects in the Backup Catalog only.
From the Backup Catalog, click Backup Configuration > Retention Policy. On the Retention Policy Scheduler section, set the Enable Retention Policy Scheduler to Yes or No.
  • Yes: Enables the retention policy scheduler and allows SAP HANA to delete older backups from IBM Storage Protect Server, and cleans up the associated objects in the Backup Catalog.
  • No: Doesn't apply any retention policy, and the database backups in IBM Storage Protect Server are deleted by the Data Protection for SAP HANA MAX_VERSIONS policy.
Note: If you choose Yes, you must go to the MAX_VERSIONS parameter in the Data Protection for SAP HANA profile, and set it to zero. This then enables the SAP HANA Cockpit to do all of the backup expiration, without interfering with Data Protection for SAP HANA settings.

Procedure

To manually delete Backup Catalog objects for database backups that have been expired in Data Protection for SAP HANA, complete the following steps.
  1. Set the Retention Policy Scheduler to No as described previously.
  2. From the SAP HANA Cockpit Home screen, click the Resource Directory to display your database systems.
  3. In the Resource column, click the database name that you are interested in, and this displays the System Overview.
  4. On the System Overview page, go to the Database Backups pane and click Database Backups. The Backup Catalog opens.
  5. On the Backup Catalog for your selected system, display the database backups in horizontal-stacked view, rather than table format.
  6. Click on a backup that you know has been expired in Data Protection for SAP HANA, and a summary of that backup generation is displayed.
  7. On the summary display, click Delete Backup Generations. The Delete Backup Generations modal window opens, and the following options are displayed.
    • Remove from backup catalog only.
    • Also delete physically: From file system; From Backint.
  8. Click the Remove from backup catalog only option, and then click Delete.
    The Backup Catalog objects for the selected database are deleted, which reduces the size of the Backup Catalog and optimizes SAP HANA performance.
    Note: If you want to configure SAP HANA Cockpit to automatically delete Backup Catalog objects, including the database backups from IBM Storage Protect Server:
    • In the Data Protection for SAP HANA profile, set the MAX_VERSIONS parameter to zero.
    • In SAP HANA Cockpit, set the Retention Policy Scheduler to Yes, and configure the retention settings for the backup generations.
    For more information, see the SAP HANA Administration guide.