You want to create a copy of the database.As a consequence of a logical error, the database needs to be reset to its state at a particular point in time.It may be necessary to recover the SAP HANA database in the following situations: During recovery, the database therefore cannot be accessed by end users or applications. To recover a SAP HANA database, the database needs to be shut down. The SQL Command to perform a full data backup follows the syntax: BACKUP DATA USING FILE ('')Īlthough automatic checks take place while complete data backups and log backups are performed, you should manually re-check the integrity of any backup if it is copied or moved to another location. The backup will finish with the summary page. The backup will then show you the backup status and then finish. ** For a multi-tenant database, you will have the option to backup the system database and the tenant database. Open SAP HANA Studio and on the navigator side (left hand side) expand your system and double click the ‘Backup’ icon You can perform a full data backup through HANA Studio and also through SQL Statements. In order to do a backup, the user will need the following privileges For an in-depth explanation of the backup and recovery process, please see the Admin guide. At the end of this guide, there will be frequently asked questions and common problems that are encountered. This page is to explain the steps on how to perform a basic backup and recovery.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |