sqlservr Application

The sqlservr application starts, stops, pauses, and continues an instance of Microsoft® SQL Server™ 2000 from a command prompt.

Syntax

sqlservr [-sinstance_name] [-c] [-dmaster_path] [-f]
    [-eerror_log_path] [-lmaster_log_path] [-m]
    [-n] [-Ttrace#] [-v] [-x] [-g number] [-O] [-y number]

Arguments

-sinstance_name

Specifies the instance of SQL Server to connect to. If no named instance is specified, sqlservr starts the default instance of SQL Server.

Important  When starting an instance of SQL Server, you must use the sqlservr application in the appropriate directory for that instance. For the default instance, run sqlservr from the \MSSQL\Binn directory. For a named instance, run sqlservr from the \MSSQL$instance_name\Binn directory.

-c

Indicates that an instance of SQL Server is started independently of the Windows NT Service Control Manager. This option is used when starting SQL Server from a command prompt, to shorten the amount of time it takes for SQL Server to start. (Note that when you use this option, you cannot stop SQL Server by using SQL Server Service Manager or the net stop command, and if you log off the Microsoft Windows NT® system, SQL Server will be stopped.)

-dmaster_path

Indicates the fully qualified path for the master database file. There are no spaces between -d and master_path.

-f

Starts the server in minimally configured mode. The system administrator can then reconfigure configuration options (with the sp_configure system stored procedure).

-eerror_log_path

Indicates the fully qualified path for the error log file. If not specified, the default location is x:\Program Files\Microsoft SQL Server\MSSQL\Log\Errorlog for the default instance and x:\Program Files\Microsoft SQL Server\MSSQL$instance_name\Log\Errorlog for a named instance. There are no spaces between -e and error_log_path.

-lmaster_log_path

Indicates the fully qualified path for the master database transaction log file. There are no spaces between -l and master_log_path.

-m

Indicates to start an instance of SQL Server in single-user mode. Only a single user can connect when SQL Server is started in single-user mode. The CHECKPOINT mechanism, which guarantees that completed transactions are regularly written from the disk cache to the database device, is not started. (Typically, this option is used if you experience problems with system databases that require repair.)

-n

Indicates that you do not want to use the Windows NT application log to log SQL Server events. If you start an instance of SQL Server with the -n option, it is advisable to use the -e option too, or SQL Server events are not logged.

-Ttrace#

Indicates that an instance of SQL Server should be started with a specified trace flag (trace#) in effect. Trace flags are used to start servers with nonstandard behavior. For more information about available trace flags (trace#), see Trace Flags.

Important  When specifying a trace flag, use -T to pass the trace flag number. A lowercase t (-t) is accepted by SQL Server; however, -t sets other internal trace flags required by SQL Server support engineers.

-v

Displays the server version number.

-x

Disables maintaining CPU statistics.

-g memory_to_reserve

Specifies an integer number of megabytes of memory to reserve for other applications running within (in-process) SQL Server 2000.

-O

Specifies that Distributed COM (DCOM) is not required, thereby disabling heterogeneous queries.

-y error_number

If SQL Server 2000 encounters an error message specified in this option, it writes the symptom stack trace to the error log. You can specify multiple errors by using multiple –y arguments.