Backup and restore performance improvements with many tables, views, and procedures
Netezza Performance Server includes enhancements to back up and restore that significantly improve performance when the database that is being backed up and restored has many tables and or other objects that rarely change.
Both incremental backup and incremental restore include optimizations that eliminate unnecessary processing overhead for tables and other objects that are known not to have been modified since the last backup. Specifically, views and procedures. In addition, you can designate staging or other temporary-use tables as not needing backup, and both full and incremental backups eliminate unnecessary processing overhead for these tables.
Restore and backup operations must be performed on systems with the same identifier case.
For example: A backup taken on a lowercase system must be restored on a lowercase system.