sqlservr Command-line Executable

Is the SQL Server executable program.

Syntax

sqlservr [/c] [/dmaster_device_path] [/f] [/eerror_log_path] [/m] [/n]
    [/pprecision_level] [/rmaster_mirror] [/sregistry_key] [/Ttrace#] [/x]

where

/c

Indicates to start SQL Server independent of the Windows NT Service Control Manager. This option is used when starting SQL Server from the command line 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 using the SQL Service Manager or the net stop command. And if you log off from the Windows NT system, the SQL Server will be stopped.)

/dmaster_device_path

Indicates the fully qualified path for the MASTER database device (typically, C:\SQL60\DATA\MASTER.DAT). Note that there is no space between /d and master_device_path.

/f

Starts the server in minimally configured mode. The system administrator can then reconfigure configuration options (with the sp_configure system stored procedure) and avoid using the bldmastr command-line utility.

/eerror_log_path

Indicates the fully qualified path for the error log file (typically, C:\SQL60\LOG\ERRORLOG). If you do not specify this option, an error log is not written. Note that there is no space between /e and error_log_path.

/m

Indicates to start SQL Server in single-user mode. When you start SQL Server in single-user mode, only a single user can connect, and 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 need to be repaired.)

/n

Indicates that you do not want to use the Windows NT event 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 will not be logged.

/pprecision_level

Specifies the maximum level of precision to be supported by decimal and numeric datatypes. 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 is supplied with the /p parameter, a maximum precision of 38 will be allowed for decimal and numeric datatypes.

/rmaster_mirror

Indicates the fully qualified path for the device used to mirror the MASTER database device. Use this option when starting SQL Server if the MASTER database device is damaged. (SQL Server always attempts to use the primary device specified by the /d option before it uses the mirror device specified by the /r option.)

/sregistry_key

Indicates that you want to start SQL Server using an alternate set of startup parameters stored in the Windows NT Registry under the key registry_key. This option, which can be run only from the command line, 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 the server with non-standard behavior. For a list of available trace flags (trace#), see the Trace Flags topic.

Important When specifying a trace flag, use /T to pass the trace flag number. A lower case t (/t) is accepted by SQL Server; however, /t sets other internal trace flags that are needed only by SQL Server support engineers.

/x

Disables maintaining CPU statistics.