SqlServer启动参数（国外英文资料）.doc

SqlServer启动参数（国外英文资料） The sqlserv.exe runs the parameters. The start of the SqlServer can be a Windows service (default), or it can be started in an application mode. The following is an introduction to the parameter problem when the sqlservr.exe is started with an application. Sqlservr application usage: Sqlservr [-sinstance_name] [-dmaster_path] [-f] [-eerror_log_path] [- lmaster_log_path] [-m] [-v] [-] [-] [-] The -s instance_name Specify the SQLServer instance to be connected to. If the named instance is not specified, the sqlservr will start the SQLServer default instance. When you start a SQLServer instance, you must use the sqlservr application from the appropriate directory where the instance is located. For the default instance, run sqlservr from the \ MSSQL \ Binn directory. For the named instance, run the sqlservr in the \ MSSQL $instance_name \ Binn directory. - c The SQLServer instance is started in a way that is independent of the WindowsNT service control manager. When you start the SQLServer from the command prompt, you can use this option to shorten the time to start the SQLServer. (note: when using this option, the SQLServer cannot be stopped by using the SQLServer service manager or netstop command, and the SQLServer will be stopped if the system is logged out of the system.) - dmaster_path points out the full legal path of the master database file. There is no space between -d and master_path. The -f Start the server with minimal configuration mode. The system administrator can then reconfigure the configuration options (using the sp_configure system stored procedure). - eerror_log_path The full legal path of the error log file is represented. If the path is not specified, the default instance is x: \ ProgramFiles \ MicrosoftSQLServer \ MSSQL \ Log \ Errorlog, and the default location for the named instance is x: \ ProgramFiles \ MicrosoftSQLServer \ MSSQL $instance_name \ Log \ Errorlog. There is no space between -e and error_log_path. - lmaster