Note: I assume SQL Server is not part of a clustered environment here, if your SQL Server instance is part of a cluster, then use the failover cluster manager instead!
There are a bunch of way to shut down SQL Server, here is how you can do it
SSMS Object Explorer
The process from SSMS is very similar to Configuration Manager, right click on the instance and select Stop
From SSMS open a new query window and type shutdown or shutdown with nowait
Unless the WITHNOWAIT option is used, SHUTDOWN shuts down SQL Server by:
- Disabling logins (except for members of the sysadmin and serveradmin fixed server roles).
- Waiting for currently running Transact-SQL statements or stored procedures to finish. To display a list of all active processes and locks, run sp_who and sp_lock, respectively.
- Inserting a checkpoint in every database.
That seems kinda dangerous can someone pass that command to a proc by masking it?
The SHUTDOWN statement cannot be executed within a transaction or by a stored procedure. Msg 0, Level 11, State 0, Line 3 A severe error occurred on the current command. The results, if any, should be discarded.
That is good to know :-)
Open a command prompt as administrator and type net stop MSSQLSERVER
To start SQL Server again, change net stop to net start
Below are a couple of more ways but you should really not be using those!!
Yes, you can kill SQL Server from task manager
You can use the plain old DOS command taskkill as well
Shutdown your server
That is one way of course but you might get a bunch of people yelling at you
Unplug the power to your server after making sure you have no UPS battery backup plugged in
Great way to test recovery... .. sarcasm people.....
Shutdown the data center
You laugh but this actually happened to me once, someone did some work and shut down the whole development part of the data canter. We had SQL Server 2000 running on NT 4, it was not restarted in 6 years (meaning wasn't patched either) It was an isolated box, internal ip, couldn't be reached from outside the dev network
There you have all the ways that you can use to shut down SQL Server