Restore a full backup set

Deployment options: Netezza Performance Server for Cloud Pak for Data System Netezza Performance Server for Cloud Pak for Data

A full restore restores the entire contents of a backup set (one full plus all the incrementals). By default the nzrestore command finds the most recent backup set for the database.

For example, the following command line restores the database dev from the backup set that is stored in a NetBackup system.

nzrestore -db dev -connector netbackup

You can override the default host and database. For example, to specify another host use the -npshost option (where -npshost is the source system that created the backup), and to specify another database, specify the -sourcedb option.

nzrestore -db dev -connector netbackup -npshost nps_dev -sourcedb
mydev

If you do not want to restore the most recent backup set, you can specify a specific backup set with the -backupset option.

nzrestore -db dev -connector netbackup -backupset 20060623200000

Note: Use the -incrementlist option to view a report that lists all full and incremental backups.