Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a general use laptop. I use it for games, development, and web surfing. I've just installed SQL Server 2008 with Analysis, Reporting, and Error reporting, as well as any of the other options on the installer.

I also have a default instance of SQL server as well as a named instance.

When I'm not doing development, I'd like to shut down these services conveniently. I'm thinking that a batch file would be good. What are the commands to shut these services down and release the associated memory and resources?

It appears that:


seems to stop the MSSQLSERVER instance. What about the other services?

share|improve this question
up vote 2 down vote accepted

Just as for any other service, you can use either the Service name or the Display name as it appears in the services configuration (Administrative Tools->Services):

enter image description here

net stop "SQL Server Analysis Services (MSSQLSERVER)"


net stop MSSQLServerOLAPService
share|improve this answer
Also from PowerShell you can use Stop-Service. Put the commands in a couple of scripts to make starting and stopping as a group easier (this would also allow you to wait for dependent services -- like Agent -- to stop before stopping the dependency). – Richard Feb 4 '11 at 9:44

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.