Database completeness

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

By using the nzbackup and nzrestore commands, you provide a transactionally consistent, automated backup and restore of the definitions and data for all objects of a database, including ownership and permissions for objects within that database. You can use these commands to back up and restore an entire database, and to restore a specific table in a database.

The nzrestore command requires the database to be dropped or empty before you restore the database. Similarly, before you restore a table, you must first drop the table or use the -droptables option to allow the command to drop a table that is going to be restored.