In this Blog I will be explaining about Backup automation of SAP IQ database and how we can schedule regular backups using SAP IQ cockpit.
for scheduling backups in SAP IQ we have first create events object in the IQ Cockpit.
Here is reference SAP Note for how to create event : https://launchpad.support.sap.com/#/notes/2743607
So for creating events login to SAP IQ db
execute below command for creating backup event using isql
CREATE EVENT FullBackup SCHEDULE START TIME ‘1:00AM’ EVERY 24 HOURS HANDLER BEGIN BACKUP DATABASE full TO ‘/backup/path/IQ_FULL_BKP’ END
This will create a backup event name ” FullBackup ” which will run at 1:00 AM daily
Now we can manage this using IQ cockpit as shown below
Click on explore tab > complied objects > Event
You have to select the event which you want to manage and click on Action button on top right corner.
on SQL you can change the backup command.
on schedules tab you can manage the time on which you want to run backup
Please note that backups scheduled using events generate backup file size of 2 GB each.
Hence if the size of database it large it will generate many files of 2 GB.
Currently SAP is working on the bug fix and you can subscribe to KBA 2697951 – SIZE clause ignored when BACKUP statement is in a procedure – SAP IQ