Share via


Starting SQL Server with Minimal Configuration

If you have configuration problems that prevent the server from starting, you can start an instance of Microsoft SQL Server by using the minimal configuration startup option. This is the startup option -f. Starting an instance of SQL Server with minimal configuration automatically puts the server in single-user mode.

When you start an instance of SQL Server in minimal configuration mode, note the following:

  • 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.

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.

Important

Use the sqlcmd utility and the dedicated administrator connection (DAC) to connect to SQL Server. If you use a typical connection, stop the SQL Server Agent service before connecting to an instance of SQL Server in minimal configuration mode. Otherwise, the SQL Server Agent service uses the connection, thereby blocking it.

See Also

Tasks

How to: Start an Instance of SQL Server (sqlservr.exe)

Concepts

Using a Dedicated Administrator Connection
Setting Server Configuration Options
Using the SQL Server Service Startup Options

Other Resources

sqlcmd Utility
sp_configure (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance