To be prepared for hardware or software failure on Adaptive Server:
Perform frequent backups of the master database and all user databases. See “Keep up-to-date backups of master”, and Chapter 13, “Restoring the System Databases,” in System Administration Guide: Volume 2.
Keep a copy (preferably offline) of these system tables: sysusages, sysdatabases, sysdevices, sysloginroles, and syslogins. See “Keep offline copies of system tables”. If you have copies of these scripts, and a hard-disk failure or other disaster makes your database unusable, you can use the recovery procedures described in Chapter 13, “Restoring the System Databases,” in System Administration Guide: Volume 2. If you do not have current copies of your scripts, it is much more difficult to recover Adaptive Server when the master database is damaged.
