Ideally, you should create databases, create database objects, and configure Adaptive Server using script files that you later store in a safe place. Storing the script files use makes it possible to re-create your entire system in the event of a disaster. It also allows you to re-create database systems quickly on new hardware platforms for evaluation purposes. 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
It is also helpful to 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.
