Table-level restore syntax
nzrestore -db <dbname> -connector <filesystem> -dir <root dir>
[<opts>] -tables <table1> [ ...]
As in a standard restore, by default the system restores the table's definition and data. To skip the data restore, use the -noData option.
- You can specify the nzrestore command-line options in any order.
- If your table names contain spaces, enclose the names in double quotation marks.
- If your table names begin with dashes (-), you can restore them by listing them in a single file and by using the -tablefile option.
- You can restore to a different target database than the original backup (use the -sourcedb option to find the backup).
- If the target database does not exist, the system creates it.
- Specify the table name in the letter case form (uppercase or lowercase) that matches the name in the backup set.
- If the backup set for a database includes multiple schemas, and the table name is not unique because it is used in more than one schema, the system displays the message Error: More than one table having name 'TABLENAME' found in the backup. Specify -sourceschema option. You must specify the schema where the table is defined in the backup set to uniquely identify the table.
- If the table exists in the database with the same name as the table you are restoring, both copies of the table exist until the transaction is complete. If there is not enough disk space for both versions of the table, you must manually drop the table before you run the table-level restore.