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).
Sql-server – the best and easiest way to turn off SQL Server when not in use
sql server
Related Question
- Sql-server – What are the advantages of having a centralised SQL database server for development
- SQL Server – Restrict Table Inserts to Trigger Only
- Sql-server – What are options for Bi-Directional Replication of SQL Azure Database
- SQL Server 2008 – ‘The Computer Must Be Trusted for Delegation’ Error
- Sql-server – Turn TDE off when restoring SQL databases
Best Answer
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.