Recovering from a failed upgrade

The procedure for recovering from a failed upgrade is:

  1. Fix the underlying problem

  2. Rerun the upgrade utility, $SYBASE/$SYBASE_ASE/upgrade/upgrade

  3. Reinstall system stored procedures using the scripts from the new version

isql -Usa -P<password> -i $SYBASE/$SYBASE_ASE/scripts/installmaster

NoteIf Adaptive Server crashes (e.g., if there's a power failure) while upgrade is in progress, when it is restarted it will attempt to upgrade databases while it is booting. Messages for this upgrade will go to Adaptive Server's console (the terminal or window where it was started). After this finishes, and the installation is fully recovered, re-run the upgrade utility. This assures that all post-upgrade configuration work is done. Then reinstall system stored procedures as previously described