cancel
Showing results for 
Search instead for 
Did you mean: 

How to speed-up large IQ database backup

SAPSupport
Employee
Employee
0 Kudos
143

Hi SAP,

Our SAP IQ DB size is high, and backup is taking approximately 12 hours to complete.
Could you please let us know how we can optimize the backup so that the backup time will get reduced.

 


------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.
View Entire Topic
SAPSupport
Employee
Employee
0 Kudos

I advise (general recommendations)

  • Review you backup strategy: Eg. use less full backup and more increment backups

  • Perform full backup during low activity (if possible) and increase max threads for the user performing the full backup. 
    See KBA 0003513918 Full backup is very slow in Large Database - SAP IQ

  • You may consider Virtual Backup method :
       0002461985 - How to Backup Large SAP IQ Database