sql, sql express, and ability to turn off

Posted on 2013-09-27
Medium Priority
Last Modified: 2013-10-01
I have a msdn action pack subscription so I have the ability to download sql if I would like.  I wanted to do some work with a very very large db which I have on disk.  It's actually a lot of databases but the total size is around a TB.  I won't be using this much and don't want sql slowing my machine down all the time for no reason.

Is there an easy way to turn on and off the sql services?  Would it be safer to just use sql express?  I am not going to be making a lot of connections.  My main goal is that it won't kill my machine and I don't have to search for and turn on and off a lot of services.

This will be running on a windows 7 boot to vhd machine.
Question by:jackjohnson44
LVL 75

Accepted Solution

Aneesh Retnakaran earned 1000 total points
ID: 39529085
services 'SQL server .... ' and 'SQL server agent '' can be disabled as required. Go to control panel services,  You can also disable the other services like , sql browser and SQL VSS,
LVL 16

Assisted Solution

DcpKing earned 1000 total points
ID: 39529132
Go to where you have SQL Server installed in the menu system and you'll find Configuration Tools and then SQL Server Configuration Manager. That's the best place to turn things on and off, because it "knows" what needs what, etc.



Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question