以最小配置启动 SQL ServerStart SQL Server with Minimal Configuration

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions)

如果存在配置问题而无法启动服务器,可使用最小配置启动选项来启动 MicrosoftMicrosoft SQL ServerSQL Server 实例。If you have configuration problems that prevent the server from starting, you can start an instance of MicrosoftMicrosoft SQL ServerSQL Server by using the minimal configuration startup option. 这就是启动选项 -fThis is the startup option -f. 使用最小配置启动 SQL ServerSQL Server 实例会自动将服务器置于单用户模式。Starting an instance of SQL ServerSQL Server with minimal configuration automatically puts the server in single-user mode.

在最小配置模式下启动 SQL ServerSQL Server 实例时,注意下列事项:When you start an instance of SQL ServerSQL Server in minimal configuration mode, note the following:

  • 只有一个用户可以连接,并且不会执行 CHECKPOINT 进程。Only a single user can connect, and the CHECKPOINT process is not executed.

  • 远程访问和预读功能将被禁用。Remote access and read-ahead are disabled.

  • 启动存储过程将不运行。Startup stored procedures do not run.

  • 将以最小大小配置 tempdbtempdb is configured at the smallest possible size.

  • 审核将处于禁用状态,但仍可发出审核 DDL。Audit will be disabled but Audit DDL can still be issued. 实际上,-m 应该足以满足大多数需要 SQL Server 审核重新配置的情况。In practice, -m should be sufficient for most cases that require SQL Serve Audit reconfiguration. 有关审核配置中的安全性的更多详细信息,请参阅 SQL Server 中的审核For more details about security in Auditing configuration, see Auditing in SQL Server.

用最小配置启动服务器后,应更改相应的服务器选项值,然后停止并重新启动服务器。After the server has been started with minimal configuration, you should change the appropriate server option value or values, stop, and then restart the server.

重要

使用 sqlcmd 实用工具和专用管理员连接 (DAC) 连接到 SQL ServerSQL ServerUse the sqlcmd utility and the dedicated administrator connection (DAC) to connect to SQL ServerSQL Server. 如果使用典型连接,则在最小配置模式下连接到 SQL ServerSQL Server 实例之前,停止 SQL Server 代理服务。If you use a typical connection, stop the SQL Server Agent service before connecting to an instance of SQL ServerSQL Server in minimal configuration mode. 否则,SQL Server 代理服务将使用该连接从而使其阻塞。Otherwise, the SQL Server Agent service uses the connection, thereby blocking it.

另请参阅See Also

启动、停止或暂停 SQL Server 代理服务 Start, Stop, or Pause the SQL Server Agent Service
用于数据库管理员的诊断连接 Diagnostic Connection for Database Administrators
sqlcmd 实用工具 sqlcmd Utility
服务器配置选项 (SQL Server) Server Configuration Options (SQL Server)
sp_configure (Transact-SQL) sp_configure (Transact-SQL)
数据库引擎服务启动选项Database Engine Service Startup Options