Skip to content

Latest commit

 

History

History
49 lines (38 loc) · 2.84 KB

File metadata and controls

49 lines (38 loc) · 2.84 KB
title Start SQL Server with Minimal Configuration | Microsoft Docs
ms.custom
ms.date 01/20/2017
ms.prod sql
ms.prod_service high-availability
ms.reviewer
ms.suite sql
ms.technology configuration
ms.tgt_pltfrm
ms.topic conceptual
helpviewer_keywords
minimal configuration [SQL Server]
starting SQL Server, minimal configuration
ms.assetid 4d733c99-28b3-42d8-b7f6-7b943b548173
caps.latest.revision 27
author MikeRayMSFT
ms.author mikeray
manager craigg

Start SQL Server with Minimal Configuration

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]

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

When you start an instance of [!INCLUDEssNoVersion] 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.

  • tempdb is configured at the smallest possible size.

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 [!INCLUDEssNoVersion]. If you use a typical connection, stop the SQL Server Agent service before connecting to an instance of [!INCLUDEssNoVersion] in minimal configuration mode. Otherwise, the SQL Server Agent service uses the connection, thereby blocking it.

See Also

Start, Stop, or Pause the SQL Server Agent Service
Diagnostic Connection for Database Administrators
sqlcmd Utility
Server Configuration Options (SQL Server)
sp_configure (Transact-SQL)
Database Engine Service Startup Options