Change the SQL server service for SQL Server 2012 2014 to this
adding -m to the startup parameters.
Before you do that you really want to
- Get everyone off the server.
- Disable SQL Agent service changing to manual
- Close any SSMS object explorer windows you or other administrators have open.
- Remember it’s single user mode.
- Stop the services, for SQL and any others which may automatically reconnect once SQL is back up.
- Possibly leave SSMS open with a query window with the commands you want to run in single user mode.
Click and restart the SQL service. After it has restarted [re-]open a SSMS query window and run the commands.
Once done
- Stop SQL Service
- Change the properties removing the -m from the startup parameters
- Change SQL Agent to autostart and or whatever else you had to change to aget SQL into single user mode.