Table of Contents
A full backup of your SAP HANA Cloud database is taken automatically once per day. Nevertheless, as a save measure we can create an Automation Pilot command which verifies that there was a recent backup of the database.
This example command performs an SQL query to find the most recent backup by pulling The pulling data from the M_BACKUP_CATALOG system view. If the last successful backup is older than the specified threshold, the execution fails with an error message:
To use this example you'll need the following:
- SAP HANA Cloud database
- Database user
- JDBC URL of the following format:
jdbc:sap://<endpoint>:<port> - Allowed connections from Automation Pilot to your HANA Cloud database. Use this procedure to add the NAT IPs of the relevant Automation Pilot region.
Check out the following resources for more information:
- Deploy SAP HANA Cloud
- Create Users and Manage Roles and Privileges
- Connect to the SAP HANA Database in SAP HANA Cloud via JDBC
Import the content of examples catalog in your Automation Pilot tenant. Navigate to the CheckHanaCloudBackup command and trigger it.
You'll need to provide values for the following input keys:
- connectionUrl - JDBC connection URL for the database
- user - Name of a database user
- password - Password for the specified database user
- ageThreshold - Backup age threshold in days. Defaults to 3 days
This command is most useful when executed every day. Automation Pilot allows executions to be automatically triggered on regular intervals - hourly, daily, weekly, monthly or yearly. You can find more details in the documentation.
Another important aspect is alerting. It's important to receive notifications (in the form of email, slack message, Jira ticket or other) whenever the CheckHanaCloudBackup command fails to find a recent backup. This could be easily achieved with the help of SAP Alert Notification. More information can be found here.