Start Adaptive Server in master-recover mode with the -m (UNIX and Windows) option.
On UNIX platforms – make a copy of the runserver file, naming it m_RUN_server_name. Edit the new file, adding the parameter -m to the dataserver command line. Then start the server in master-recover mode:
startserver -f m_RUN_server_name
On Windows – start Adaptive Server from the command line using the sqlsrver command. Specify the -m parameter in addition to other necessary parameters. For example:
sqlsrver.exe -dD:\Sybase\DATA\MASTER.dat -sPIANO -eD:\Sybase\install\errorlog -iD:\Sybase\ini -MD:\Sybase -m
See the Utility Guide for the complete syntax of these commands.
When you start Adaptive Server in master-recover mode, only one login of one user—the system administrator—is allowed. Immediately following a dataserver command on the master database, only the “sa” account exists, and its password is NULL.
WARNING! Some sites have automatic jobs that log in to the server at start-up with the “sa” login. Be sure these are disabled.
Master-recover mode is necessary because the generic master database created with dataserver does not match the actual situation in Adaptive Server. For example, the database does not know about any of your database devices. Any operations on the master database could make recovery impossible or at least much more complicated and time-consuming.
An Adaptive Server started in master-recover mode is automatically configured to allow direct updates to the system tables. Certain other operations are disallowed.
WARNING! Ad hoc changes to system tables are dangerous—some changes can render Adaptive Server unable to run. Make only the changes described in this chapter, and always make the changes in a user-defined transaction.
