Back up and restore stored procedures

Any stored procedures that you create are backed up and restored by the backup and restore operations. If you back up and restore obfuscated procedures, those restored procedures remain obfuscated. If you restore a database to a system that is running a release which does not support obfuscated procedures or VARARGS, for example, those procedures will not run and the queries that use them will return a syntax error.

If you drop a database, all the objects defined in the database including stored procedures are likewise dropped. If the Netezza Performance Server system supports multiple schemas in a database, and you define stored procedures in that schema, dropping the schema will likewise drop all the objects in that schema. As a best practice, you should keep backup copies of your source CREATE OR REPLACE PROCEDURE definitions in a safe location outside of the Netezza Performance Server system. Make sure that you have recent backups of your Netezza Performance Server systems in the event that you need to recover from an accidental deletion or change, or to restore Netezza Performance Server services as part of a disaster recovery situation.