Showing results for 
Search instead for 
Did you mean: 

we need to setup HA-DR Installation for SAP IQ database in Production ?

0 Kudos

As a part of Archive Project we have to setup a sandbox , QAS & Production Server.

Production Server in HA-DR Setup with SAP IQ 16 version database?

how can we achieve HA-DR Setup SAP IQ? what about license part?


Ashish Chanekar

Accepted Solutions (0)

Answers (2)

Answers (2)

Product and Topic Expert
Product and Topic Expert
0 Kudos

The standard approach to providing HA for SAP IQ systems is to implement an IQ Multiplex (scale out) configuration.

SAP IQ Administration: Multiplex

Disaster recovery is provided through backup and restore processes. Unfortunately SAP IQ is not supported as a source for data replication.

SAP IQ Administration: Backup, Restore, and Data Recovery

Active Contributor
0 Kudos

Hello ashish_chanekar

The HA setup for ILM/NLS with IQ is not mandantory relevant for this use case, as the data can be backup even offline, as once the data is transferred to the IQ Server, there is no HA dependency from IQ to the SAP necessary.Never the less, there is the following possible- HW disk mirroring
- standby database while setup of the SAP IQ server
- the IQ MPX Architecture is not suitable for these use cases nor HA scenarioAs you not specified if the SAP use case is either NLS or ILM, please have a look to the Blog - SAP (Sybase) IQ – the hidden treasure …For the License Details see the Document - SAP First Guidance – SAP NLS Solution with SAP IQ 16.xBest Regards RolandPlease follow the Rules of Engagement