Back up SAP HANA database instance snapshots on Azure VMs

This article describes how to back up SAP HANA database instances that are running on Azure VMs to an Azure Backup Recovery Services vault.

Azure Backup now performs an SAP HANA storage snapshot-based backup of an entire database instance. Backup combines an Azure managed disk full or incremental snapshot with HANA snapshot commands to provide instant HANA backup and restore.

For more information about the supported configurations and scenarios, see SAP HANA backup support matrix.

Before you start

Policy

According to SAP, it's mandatory to run a weekly full backup of all databases within an instance. Currently, logs are also mandatory for a database when you're creating a policy. With snapshots happening daily, we don’t see a need for incremental or differential backups in the database policy. Therefore, all databases in the database instance, which is required to be protected by a snapshot, should have a database policy of only weekly fulls + logs ONLY, along with daily snapshots at an instance level.

To summarize the backup policy:

• Always protect all databases within an instance with a database policy before you apply daily snapshots to the database instance.
• Make sure that all database policies have only Weekly fulls + logs and no differential/incremental backups.
• Do not trigger on-demand Backint-based streaming differential or incremental backups for these databases.

Permissions required for backup

You must assign the required permissions to the Azure Backup service, which resides on a HANA virtual machine (VM), to take snapshots of the managed disks and place them in a user-specified resource group that's mentioned in the policy. To do so, you can use the system-assigned managed identity of the source VM.

The following table lists the resource, permissions, and scope.

When you're assigning permissions, consider the following:

• The credentials that are used should have permissions to grant roles to other resources and should be either Owner or User Access Administrator, as mentioned in the steps for assigning user roles.

• During backup configuration, you can use the Azure portal to assign the previously mentioned permissions, except Disk Snapshot Contributor to the Backup Management Service principal for the snapshot resource group. You need to manually assign this permission.

• We recommend that you not change the resource groups after they're given or assigned to Azure Backup, because it makes it easier to handle the permissions.

Learn about the permissions required for snapshot restore and the SAP HANA instance snapshot backup architecture.

Establish network connectivity

Learn about the network configurations required for HANA instance snapshot.

Create a Recovery Services vault

A Recovery Services vault is a management entity that stores recovery points that are created over time, and it provides an interface to perform backup-related operations. These operations include taking on-demand backups, performing restores, and creating backup policies.

To create a Recovery Services vault:

1. Sign in to the Azure portal.

2. Search for Backup center, and then go to the Backup center dashboard.

   

3. On the Overview pane, select Vault.

   

4. Select Recovery Services vault > Continue.

   

5. On the Recovery Services vault pane, enter the following values:

   • Subscription: Select the subscription to use. If you're a member of only one subscription, you'll see that name. If you're not sure which subscription to use, use the default subscription. There are multiple choices only if your work or school account is associated with more than one Azure subscription.

   • Resource group: Use an existing resource group or create a new one. To view a list of available resource groups in your subscription, select Use existing, and then select a resource in the dropdown list. To create a new resource group, select Create new, and then enter the name. For more information about resource groups, see Azure Resource Manager overview.

   • Vault name: Enter a friendly name to identify the vault. The name must be unique to the Azure subscription. Specify a name that has at least 2 but not more than 50 characters. The name must start with a letter and consist only of letters, numbers, and hyphens.

   • Region: Select the geographic region for the vault. For you to create a vault to help protect any data source, the vault must be in the same region as the data source.

     Important

     If you're not sure of the location of your data source, close the window. Go to the list of your resources in the portal. If you have data sources in multiple regions, create a Recovery Services vault for each region. Create the vault in the first location before you create a vault in another location. There's no need to specify storage accounts to store the backup data. The Recovery Services vault and Azure Backup handle that automatically.

     

6. After providing the values, select Review + create.

7. To finish creating the Recovery Services vault, select Create.

   It can take a while to create the Recovery Services vault. Monitor the status notifications in the Notifications area at the upper right. After the vault is created, it appears in the list of Recovery Services vaults. If the vault doesn't appear, select Refresh.

   

Create a policy

To create a policy for the SAP HANA database instance backup, follow these steps:

1. In the Azure portal, select a Recovery Services vault.

2. Under Backup, select Backup Policies.

3. Select Add.

4. On the Select policy type pane, select SAP HANA in Azure VM (DB Instance via snapshot).

   

5. On the Create policy pane, do the following:

   

   1. Policy name: Enter a unique policy name.

   2. Snapshot Backup: Set the Time and Timezone for backup in the dropdown lists. The default settings are 10:30 PM and (UTC) Coordinated Universal Time.

      Note

      Azure Backup currently supports Daily backup only.

   3. Instant Restore: Set the retention of recovery snapshots from 1 to 35 days. The default value is 2.

   4. Resource group: Select the appropriate resource group in the drop-down list.

   5. Managed Identity: Select a managed identity in the dropdown list to assign permissions for taking snapshots of the managed disks and place them in the resource group that you've selected in the policy.

      You can also create a new managed identity for snapshot backup and restore. To create a managed identity and assign it to the VM with SAP HANA database, follow these steps:

      1. Select + Create.

         

      2. On the Create User Assigned Managed Identity page, choose the required Subscription, Resource group, Instance region, and add an Instance name.

      3. Select Review + create.

         

      4. Go to the VM with SAP HANA database, and then select Identity > User assigned tab.

      5. Select User assigned managed identity.

         

      6. Select the subscription, resource group, and the new user-assigned managed identity.

      7. Select Add.

         

      8. On the Create policy page, under Managed Identity, select the newly created user-assigned managed identity > OK.

         

   You need to manually assign the permissions for the Azure Backup service to delete the snapshots as per the policy. Other permissions are assigned in the Azure portal.

   To assign the Disk Snapshot Contributor role to the Backup Management Service manually in the snapshot resource group, see Assign Azure roles by using the Azure portal.

6. Select Create.

You'll also need to create a policy for SAP HANA database backup.

Discover the database instance

To discover the database instance where the snapshot is present, see the Back up SAP HANA databases in Azure VMs.

Configure snapshot backup

Before you configure a snapshot backup in this section, configure the backup for the database.

Then, to configure a snapshot backup, do the following:

1. In the Recovery Services vault, select Backup.

2. Select SAP HANA in Azure VM as the data source type, select a Recovery Services vault to use for backup, and then select Continue.

3. On the Backup Goal pane, under Step 2: Configure Backup, select DB Instance via snapshot, and then select Configure Backup.

   

4. On the Configure Backup pane, in the Backup policy dropdown list, select the database instance policy, and then select Add/Edit to check the available database instances.

   

   To edit a DB instance selection, select the checkbox that corresponds to the instance name, and then select Add/Edit.

5. On the Select items to backup pane, select the checkboxes next to the database instances that you want to back up, and then select OK.

   

   When you select HANA instances for backup, the Azure portal validates for missing permissions in the system-assigned managed identity that's assigned to the policy.

   If the permissions aren't present, you need to select Assign missing roles/identity to assign all permissions.

   The Azure portal then automatically re-validates the permissions, and the Backup readiness column displays the status as Success.

6. When the backup readiness check is successful, select Enable backup.

   

Run an on-demand backup

To run an on-demand backup, do the following:

1. In the Azure portal, select a Recovery Services vault.

2. In the Recovery Services vault, on the left pane, select Backup items.

3. By default, Primary Region is selected. Select SAP HANA in Azure VM.

4. On the Backup Items pane, select the View details link next to the SAP HANA snapshot instance.

   

5. Select Backup now.

   

6. On the Backup now pane, select OK.

   

Track a backup job

The Azure Backup service creates a job if you schedule backups or if you trigger an on-demand backup operation for tracking. To view the backup job status, do the following:

1. In the Recovery Services vault, on the left pane, select Backup Jobs.

   The jobs dashboard displays the status of the jobs that were triggered in the past 24 hours. To modify the time range, select Filter, and then make the required changes.

2. To review the details of a job, select the View details link next to the job name.

Next steps

Learn how to:

• Restore SAP HANA database instance snapshots on Azure VMs
• Manage SAP HANA databases on Azure VMs