> Software > Protect > AI & Analytics > SAP IQ (Sybase IQ)

Restore SAP IQ (Sybase IQ) data

You can restore SAP IQ database content to recover from deletion, corruption, or ransomware. You can restore content to the same location (in place).

Restore destinations

Destination When to use
In place Recovering from accidental deletion, database corruption, or ransomware on the original SAP IQ server

Permissions and prerequisites

Before restoring SAP IQ data, confirm that:

  • The SAP IQ database user has the BACKUP privilege (required for the RESTORE DATABASE command).

  • The OS user running the Commvault workload has read access to $IQDIR16/bin64 (to execute dbstop, start_iq, and dbisqlc utilities).

  • The OS user running the Commvault workload has write access to the SAP IQ data directories (to delete existing database files before restore).

  • The utility server password (utilSuPassword) is correct. This password is used to start a temporary utility server on port 19638 for the restore operation.

  • All users are disconnected from the SAP IQ database. The restore operation stops the IQ server, and all active connections must be closed before the server can stop cleanly.

  • If restoring an incremental backup, the corresponding full backup is available. Commvault enforces full-before-incremental ordering and applies the full backup first, followed by incremental backups in sequence.

Restore in place

You can restore SAP IQ database content to the original location.

  1. From the Command Center navigation pane, go to Protect > AI & Analytics.

  2. Click the SAP IQ configuration.

  3. On the Subclients tab, select the subclient that contains the database to restore.

  4. Click Restore.

  5. Select the recovery point (backup job) to restore from.

  6. The entire database is selected by default (SAP IQ restores are database-level only).

  7. Confirm that the restore destination is the original SAP IQ server and file paths (in-place restore).

  8. Click Submit.

The restore operation performs the following steps automatically:

  1. Stops the SAP IQ server using the dbstop utility.

  2. Deletes all existing database files discovered at backup time (catalog, IQ store, transaction log, and temporary files).

  3. Starts a temporary utility server on port 19638 using the start_iq utility with the -su (super user) password.

  4. Executes the RESTORE DATABASE command via the utility server to restore the full backup.

  5. If restoring an incremental backup, applies incremental backups in sequence after the full backup.

  6. Stops the utility server.

  7. Restarts the SAP IQ server using the original engine name and port from the backup configuration.

Restore proceeds in parent-first order:

  1. Full backup is applied first.

  2. Incremental backups are applied in sequence (if restoring an incremental backup chain).

×

Loading...