Ideally, create databases and database objects, and configure Adaptive Server using script files that you store in a safe place. Storing the script files makes it possible to re-create your entire system in the event of a disaster. You can also use script files to quickly re-create database systems for evaluation purposes on new hardware platforms. If you use a third-party tool to perform system administration, remember to generate equivalent scripts after performing administration tasks.
Consider recording the following kinds of information:
Commands used to create databases and database objects (DDL scripts)
Commands that add new Adaptive Server logins and database users
The current Adaptive Server configuration file, as described in “Using sp_configure with a configuration file”
The names, locations, and sizes of all files and raw devices initialized as database devices
Maintain a dated log of all changes to the Adaptive Server configuration. Mark each change with a brief description of when and why you made the change, as well a summary of the end result.
