You can use the following checklist when you manually rebuild Adaptive Server with bcp and the server build utility for your ASE version and platform. Details on each step follow.
Copy the system tables to files (bcp...out with the -c option).
Get configuration information and shut down the server.
Run the dataserver (Unix)/sqlsrvr (Windows) program for version 12.5 and later, or the buildmaster command on pre-12.5 versions to create the new master device.
Bring up the server in single user mode.
Delete sysconfigures, and then copy the files into the system tables (bcp...in), including sysconfigures.
Reconfigure, shut down with nowait and then restart the server.
Run the install scripts for master and model.
Shut down/bring up the server in multi-user mode.
Test the results.
