SQL Server – How to Start the SQL Server in Minimal Configuration GUI

To Start SQL Server in minimum configuration mode, we need to do the following.

Start-> All Programs -> SQL Server 2012 -> SQL Server Configuration Manager.

In Configuration manager window, we need to select corresponding SQL Server services, if multiple instances are there, Here SQL Server services

Right click on SQL Server services and choose properties -> Startup Parameters -> Add “-m” to the startup paramerters and Add it.

Please have a look at the below image.

Start SQL Server in Minimal Config Mode

 

Note:

In Minimal mode, SQL Server is started in Single User Mode.

print

Leave a Reply

Your email address will not be published. Required fields are marked *


three + 1 =