sqlservr Application

Use sqlservr to start, stop, pause, and continue Microsoft® SQL Server™ from a command prompt.

Syntax

sqlservr [-c] [-dmaster_path] [-f] [-eerror_log_path] [-lmaster_log_path] [-m]  
[-n] [-pprecision_level] [-sregistry_key] [-Ttrace#] [-v] [-x]

Arguments
-c
Indicates that 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 (typically, C:\Sql70\Log\Errorlog). If you do not specify this option, an error log is not written. 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 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 SQL Server with the -n option, it is advisable to use the -e option too, or SQL Server events are not logged.
-pprecision_level
Specifies the maximum level of precision to be supported by decimal and numeric data types. By default, SQL Server has a maximum precision of 28. The acceptable values for precision_level are from 1 through 38; however, if no precision_level value is supplied with the -p parameter, a maximum precision of 38 is allowed for decimal and numeric data types. There are no spaces between -p and precision_level.
-sregistry_key
Indicates that you want to start SQL Server using an alternate set of startup parameters stored in the Windows NT Registry under registry_key. This option, which can be run only from a command prompt, lets you select from multiple previously-defined startup configurations. You could, for example, create an alternate registry key to start SQL Server in single-user mode.
-Ttrace#
Indicates that SQL Server should be started with a specified trace flag (trace#) in effect. Trace flags are used to start servers with nonstandard behavior. For information about a list of 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 that are needed only by SQL Server support engineers.


-v
Displays the server version number.
-x
Disables maintaining CPU statistics.

(c) 1988-98 Microsoft Corporation. All Rights Reserved.