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).
Created August 28, 2013. Send feedback on this help topic to Technical Publications:
pubs@sap.com