You can enter SQL commands either by using the SQL editor in SAP HANA studio, or by using the command line program hdbsql. When all the volumes have been backed up, a confirmation message is displayed.ī) Performing a data backup using SQL commands The progress of the backup is shown for all the services (for example, the statistics server, name server, and index servers).
When all the settings are correct, choose Finish. The destination is always /usr/sap//SYS/global/hdb/backintĪ summary of the backup settings is displayed.Ħ. You do not need to use a different name for each backup.įor file-based backups, you need to ensure that there is sufficient space at the specified backup destination.įor backups with third-party backup tools, you can only change the backup prefix. The third-party backup tool can distinguish between multiple backups with the same name. The backup destination can be the same, regardless of whether you select File or Backint. The default destination is the path specified in the Backup section. Specify the backup destination and the backup prefix. Each SAP HANA service starts the Backint agent and sends the backup data to the third-party backup tool.Ĥ. O Backint Backs up the database using a third-party backup tool. Each SAP HANA service writes backup data to the specified destination in the file system. O File Backs up the database to files in the file system. Select a destination type, File or Backint: In the Navigator view, select the database that you want to back up.Ģ. There are different ways and tools to perform a data backup.Ī) Performing a data backup using SAP HANA studioġ.
What are the different ways in which you may perform a SAP HANA database data backup? What happens, if a scheduled data backup starts before the previous backup is completed? Here is a sample of questions that a typical HANA Consultant can be expected to face. SAP HANA interview questions can cover a very wide range. SAP HANA Interview Questions with Answers & Explanations Sample Questions 151 SAP HANA Interview Questions with Answers & Explanations – eBook
0 kommentar(er)
