Host backup and restore

A host backup creates a copy of the data directory and system catalog on the host. The data directory contains system tables, catalog information, configuration files, and special information for the user databases on the Netezza Performance Server, and query plans and cached executable code for the SPUs. The cache and plans directories are not backed up.

In the rare situations when a Netezza Performance Server host server or disk fails, but the SPUs and their disks are still intact, you can restore the /nz/data directory (or the directory you use for the Netezza Performance Server data directory) from the host backup without the additional time to restore all of the databases. This option works best when you have a host backup that is current with the latest database content and access settings.