Before You Restore

Before you restore, verify with Sybase Technical Support that a restore operation is necessary.

If you cannot open your database on a secondary server, synchronize the server, following the instructions in Multiplex Server Synchronization. It is never necessary to restore a coordinator node due to secondary node problems.

You can perform read-write restore operations only against a server running the utility database. You cannot run restore operations against a secondary server.

For complete syntax, see Reference: Statements and Options > SQL Statements > RESTORE Statement.

During restore operations, the database can be running only if you restore a backup of read-only files. When restoring files in a read-only dbspace, the dbspace must be offline.

You can also use the restore operation to re-create a multiplex on a different system when no problems have occurred.

Related tasks
Restoring IQ Store Data When Restoring the Database in the Same Location
Restoring IQ Store Data When Restoring Database in a Different Location