|
At the command line you can do
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.
|