--- parser: v2 auto_validation: true primary_tag: products>sap-hana-dynamic-tiering tags: [ tutorial>beginner, topic>big-data, products>sap-hana, products>sap-hana-dynamic-tiering, products>sap-hana-studio ] time: 15 slug: dt-backup-recovery-part3 canonical_url: https://developers.sap.com/tutorials/dt-backup-recovery-part3 --- # Database Recovery With HANA Dynamic Tiering Recover databases with Dynamic Tiering. ## Prerequisites - **Tutorials** [Creating Database Backups](https://www.sap.com/) - **Credentials:** Have access to the SYSTEM user of `SystemDB` and "`adm`" for a SSH session on the HANA hosts. ## You will learn - How to choose which type of recovery to perform - How to select backup location and prefixes --- ### Recovering Your Database Database recovery can be done either from a command line or from HANA Studio. The preferred way is via HANA Studio. From the SAP HANA Administrative Console perspective, right click on the System Database in the Systems panel with the `SYSTEM` user, hover over "**Backup and Recovery**" in the pop up menu and select "**Recover Tenant Database...**" Similar to backing up Tenant Databases, recovering Tenant Databases must also be done through the System Database. > Note: You can similarly select "**Recover System Database...**" to recover your System Database instead. ![Open Backup Console](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-backup-recovery-part3/open-backup-console.png) If this is your first time performing a database recovery, HANA Studio will prompt you for the user credentials of the `adm` Linux user. After, the HANA System will prompt you to confirm stopping the database. ![Shut Down System](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-backup-recovery-part3/shut-down-hana.png) Once you click OK, HANA will start to prepare the recovery wizard. When the Recovery Wizard is ready, you will be prompted to specify your Tenant system. Check the one you wish to recover and click **Next** ![Specify Tenant System](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-backup-recovery-part3/specify-tenant-database.png) Next, you will be prompted to choose the type of recovery. For the purpose of this lesson, we will be choosing to recover the database to a desired point in time. Select "**Recover the database to the following point in time.**" and then click "**Next**" ![Recover Point in Time](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-backup-recovery-part3/recovery-time-point.png) Ensure that the backup directory you will be recovering from is correct. After, click "**Next**" > Note: The default is shown directory is shown, which you can leave unmodified. This directory also needs to match the location chosen when creating the backup. ![Correct Backup Directory](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-backup-recovery-part3/correct-backup-dir.png) The backups created before the chosen time on the previous screen will appear in the recovery wizard and you can select what backup you want to recover your database to. Click the "**Check Availability**" button on the bottom right to ensure that backup is active. ![Check Backup Availability](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-backup-recovery-part3/check-backup-availability.png) Select the desired backup and click "**Next**". Ensure that the log backup directory is correct and click "**Next**" as below. > Note: The default is shown directory is shown, which you can leave unmodified. ![Check Log Backup](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-backup-recovery-part3/log-backup.png) The follow settings below will now appear. You can leave the default settings and click "**Next**". ![Other settings](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-backup-recovery-part3/other-settings.png) It will then present the "**Review Recovery Settings**" window. If the information matches what you've specified in the previous steps, then you can click "**Finish**" to run the recovery. ![Review Recovery Settings](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-backup-recovery-part3/review-recovery-settings.png) You can now view the recovery being performed for both Dynamic Tiering and the core HANA host. > Note: To perform recovery, you should have the same or higher version of SAP HANA installed as the version used to create the BACKUP ![Data Recovery Performance](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-backup-recovery-part3/watch-data-recovery.png) Once the recovery process completes, the Recovery Execution Summary screen will be displayed. ![Data Recovery Summary](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-backup-recovery-part3/recovery-summary.png) ### Test yourself