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?


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
  • 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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