Perform a full backup of an online SAP HANA database by using the HDBSQL command line interface.
Best Practice: Use the timestamp for the backup prefix. This ensures that the prefix is unique.
Before You Begin
-
Log on to the database with the key.
-
The database must be online and all services must be running.
Procedure
-
Create the following sample SQL Statement, substituting the parameters. Use a unique backup prefix.
hdbsql -U user_store_key "backup data using backint ('$(date '+%Y_%m_%d_%H_%M')_BACKUP_FILE')"