Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Situation: developer workstations that typically just use the client tools to connect to other non-local sql servers. However, there are rare times that having the full version of sql server to do local development will be beneficial. In an effort to not waste system resources running sql server all the time I would like to know the best way to "turn it off" while still allowing usage of client tools (management studio, etc).

share|improve this question

migrated from stackoverflow.com Feb 1 '12 at 14:07

This question came from our site for professional and enthusiast programmers.

3 Answers 3

up vote 6 down vote accepted

You may need to access SQL Server Configuration from the Start menu by selecting Microsoft SQL Server and then Configuration Tools, and then follow Thomas' path.

You can also configure those services so that they don't start automatically. I have mine set on "Manual", so if I want to use the SQL Server server, I just start the service. Ditto for SSIS, SSAS, SSRS, etc.

Since I have two versions of SQL Server running on my development machine, I don't want all of this stuff eating up my resources.

share|improve this answer

I'm a fan of PowerShell for this. Depending on the details of what you want to accomplish:

Stop a particular instance:

Stop-Service 'MSSQL$InstanceName' -Force

and

Start-Service 'MSSQL$InstanceName'

or to stop all SQL related services.

Stop-Service *SQL* -Force

or create a double-clickable script to toggle the state: http://orionseven.com/blog/2010/10/18/starting-and-stopping-sql-server-with-windows-powershell-2-0/

share|improve this answer

SQL Server Configuration Manager -> SQL Server Services -> Right Click -> Stop.

share|improve this answer

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.