specifies the relative path name of a runserver file, which is used as a reference each time you start an Adaptive Server or Backup Server. By default, the runserver file is in the current directory and is named RUN_servername. If you start a second Adaptive Server on the same machine, startserver creates a new runserver file named RUN_servername.
-m
starts Adaptive Server in single-user mode, allowing only one System Administrator to log in, and turns the allow updates to system tables configuration parameter on. Use this mode to restore the master database. The System Administrator can use the dbo use only parameter of sp_dboption for system administration activities that require more than one process, such as bulk copying or using the data dictionary. startserver normally starts up only one server per node.
The -m parameter creates an m_RUNSERVER file and overwrites any existing m_RUNSERVER file.
Examples Example 1
Starts an Adaptive Server named SYBASE from the runserver file named RUN_servername in the current directory:
startserver
Example 2
Starts an Adaptive Server named MYSERVER and a Backup Server named SYB_BACKUP:
startserver -f RUN_MYSERVER -f RUN_SYB_BACKUP
Example 3
Starts only the Backup Server SYB_BACKUP:
startserver -f RUN_SYB_BACKUP
Usage
startserver uses the information in the runserver file to start an Adaptive Server or Backup Server. The master device must be writable by the user who starts Adaptive Server.
The startserver command creates the Adaptive Server error log file (named errorlog) in the directory where the server is started, and adds this information as part of the -e parameter in the Adaptive Server executable line in the runserver file. If a second Adaptive Server is started on the same machine, a new error log named errorlog_servername is created; this information is added to that server's runserver file. The user must have execute permission on the specified runserver file.
You can start multiple servers by specifying more than one runserver file, as shown in example 2. You can specify -m after each -f runserverfile.
Adaptive Server derives its running environment from values in the config file. Run sp_configure or edit the config file to see or change configuration parameters.
To ensure the integrity of your Adaptive Server, it is important that you apply appropriate operating-system protections to the startserver executable and the runserver file.
The runserver file
The runserver file, which is created by srvbuild during installation, contains the dataserver command to start Adaptive Server or the backupserver command to start Backup Server. By default, the runserver file is in the current directory and is named RUN_servername. You can edit the runserver file to correct the options and parameters for the commands. The following example shows two sample runserver files.
Trace flags can be set through dbcc traceon/traceoff or added to the RUN_SERVER file (i.e. "-T292", depending on their function and the desired effect.
292 - reduces network traffic by suppressing server-to-client "done-in-proc" network packets in combination with dbcc tune(“doneinproc”,0). (Note: in previous versions of this QuickRef, trace flag 260 was mistakenly mentioned he