Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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:

net stop MSSQLSERVER

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

share|improve this question

1 Answer 1

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)"

or

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

 
discard

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.