If you write system procedures and store them in sybsystemprocs, there are two ways to recover them if the database is damaged:
Restore the database from installmaster, as described in step 4 under “Restoring sybsystemprocs with installmaster”. Then re-create the procedures by reissuing the create procedure commands.
Keep backups of the database, and load them with load database.
If you choose to keep a backup of the database, be sure that the complete backup fits on one tape volume or that more than one Adaptive Server is able to communicate with your Backup Server. If a dump spans more than one tape volume, issue the change-of-volume command using sp_volchanged, which is stored in sybsystemprocs. You cannot issue that command in the middle of recovering a database.
Following are sample load commands:
On UNIX:
load database sybsystemprocs from "/dev/nrmt4"
On Windows NT:
load database sybsystemprocs from "\\.\TAPE0"
