   |
   |
|
RESTORE
|
|
|
|
Syntax
RESTORE TABLE DATA table_path FROM SHARE {'filename' | ('filename')} [INSTANCE {instance_id | (instance_id)}]
RESTORE DATABASE database_name FROM SHARE {'filename' | ('filename')} [INSTANCE {instance_id | (instance_id)}]
RESTORE ALL FROM SHARE {'filename' | ('filename')} [INSTANCE {instance_id | (instance_id)}]
Description
For DATABASE, database_name is the target database to restore. filename is a directory containing subdirectories of databases to be restored.
If INSTANCE is given, instance_id specifies the number of the server instance of the cluster where the backup will be made. This allows you to specify on which machine the backups will go in a multi-machine cluster.
Examples
See the Backing up and Restoring page for examples.
Related