1 Version 4.0 -- 1/15/89 startserver
______________________________________________________________________
NAME: startserver
FUNCTION:
Start SQL Server.
SYNTAX:
startserver [-f runserverfile] [-m]
PARAMETERS:
-f runserverfile - lets you specify the name of a runserver file
that is used as a reference each time you restart SQL Server.
By default, the runserver file is named RUN_<servername>. If
startserver Version 4.0 -- 1/15/89 2
______________________________________________________________________
you start a second SQL Server on the same machine, a new run-
server file named RUN_<servername> is created.
The startserver command creates the error log file (named
errorlog) in the directory where you start the server, and
adds this information as part of the -e option on the
SQL Server executable line in the runserver file. If a
second SQL 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 RUN_<servername>.
The user must have EXECUTE permission on the specified run-
server file.
-m - starts SQL Server in ``single user mode'', so that only one
System Administrator can log in, and turns the allow updates
configuration variable on. This mode is used for restoring
the Master Database. The System Administrator can use the
dbo use only option of sp_dboption for system administration
3 Version 4.0 -- 1/15/89 startserver
______________________________________________________________________
activities that require more than one process, such as bulk
copying or using the data dictionary.
COMMENTS:
o The Master Database device must be writable by the user who
starts SQL Server.
o If you mirror the Master Database device, add the -r option and
the name of the mirror to the dataserver command line in the
runserver file. A runserver file that contained the line:
dataserver -d/dev/rxy1a -eerrorlog -r/server/data/master.mir
would make startserver attempt to start SQL Server using
/dev/rxy1a as the Master Database device, and a file named
master.mir as the mirror of the Master Database device. See
also the dataserver manual page.
startserver Version 4.0 -- 1/15/89 4
______________________________________________________________________
o The running environment for SQL Server is derived from values
in the sysconfigures system table. Run the system procedure
sp_configure and the Transact-SQL command RECONFIGURE to see or
to change configuration.