Multiplex Backup and Restore Operations

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 IQ Stores and Catalog Stores
  Follow these guidelines to back up multiplex databases.
• Before You Restore
  Before you restore, verify with Sybase Technical Support that a restore operation is necessary.
• Restoring IQ Store Data When Restoring Database in a Different Location
  Restore operations vary depending on where you restore the data.
• 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).