Naming tips for the configuration file

Each time you modify a configuration parameter with sp_configure, Adaptive Server creates a copy of the outdated configuration file, using the naming convention server_name.001, server_name.002, server_name.003...server_name.999.

If you want to work with a configuration file with a name other than the default name, and you keep the server_name part of the file name, be sure to include at least one alphabetic character in the extension. Alternatively, you can change the server_name to part of the file name. Doing this avoids confusion with the backup configuration files generated by Adaptive Server when you modify a parameter.