Hi experts,
I am trying to write SQL statement as below, that gets the backup ID of latest complete data backup and delete backups before the backup ID.
---------------------------------------------------------------------------------------DOB...
Hi experts,
I recently started working with SAP Sybase ASE and am trying to find a way to run full backup by batch file in background.
I have done the reserch and learned "dump database" is the SQL command to take full backup of database. Howe...
Hi experts,
Are log backups older than last data backup deleted automatically after the data backup?
If not, I wonder if log backups need to be deleted because it would take disk space.Is there any way to delete old log backups automatically, lik...
Hi experts,
I want to take data backup and delete old backups everyday using hdbsql. However, I have no idea how to know backup id of backup older than yesterday.
I know HANA studio shows all information including backup id, but I want to exec...
We have AP server(NetWeaver 7.4) and DB server(HANA 1.0 SPS12).
The goal is as below.1. Trigger HANA DB backup from .bat file on AP server running on Windows.2. Save the backup data on AP server.
Is this possible? I'm guessing HANA Client can sup...
Hi, Gopinath,Thank you for your answer.I execute the query you suggensted, but got same error...Could not execute 'DO BEGIN DECLARE Y_BACKUP_ID BIGINT; SELECT SUM(BACKUP_ID) INTO Y_BACKUP_ID FROM M_BACKUP_CATALOG ...'SAP DBTech JDBC: [257]: sql synta...
Hi Bret,Job Scheduler doesn't work out for me because I want to control when to backup using 3rd party job management software.Backup need to be run after a certain event, so time-base job scheduling was not a option for me.However, thank you for you...
Hi Dennis,Thank you for your answer! Using the command you suggested, I made the script below. I haven't run this yet, but guess this will work.SELECT SINGLE BACKUP_ID FROM M_BACKUP_CATALOG INTO Y_BACKUP_ID WHERE SYS_END_TIME = (SELECT MAX(SYS_END_...
I guess I get the result I want by create and run bat file below.Thank you for all answers!In bat filehdbsql -n <hostname>:3<instance_no>15 -i <instance_no> -u <userstore_key> -I "<SQL_file_path>"In SQL file:BACKUP DATA USING FILE ('path', 'prefix')
Hi Dennis,Yes, I want to trigger HANA database backup from application server and save it on EBS, but let me correct m words, I don't care which of application server or HANA server EBS is attached. EBS attached to application server is prefferable, ...