Back Up and Restore

Execute BACKUP and RESTORE SQL commands only on the coordinator node.

• Checking Database Consistency
  Check database consistency before backing up.
• Backup Requirements
  Execute the BACKUP SQL command only on the coordinator node.
• Backing Up Multiplex Databases
  Follow these guidelines to back up multiplex databases.
• Before You Restore
  You can perform read-write restore operations only against a server running the utility database.
• Restoring IQ Store Data When Restoring Database in a Different Location
  Restore operations vary, depending on the location from which you restore.
• Restoring IQ Store Data When Restoring the Database in the Same Location
  Restore operations vary depending on where you are restoring the data.
• Selective Restore Operations in a Multiplex Environment
  Restore databases either completely or selectively (by restoring only read-write dbspaces, or a set of read-only dbspaces or read-only files).