?
Solved

how to stop mssql

Posted on 2009-02-23
7
Medium Priority
?
808 Views
Last Modified: 2013-12-07
How can I stop and start Microsoft SQL Server 2005 Express, from the command line?
0
Comment
Question by:BobSpenc
7 Comments
 
LVL 60

Expert Comment

by:chapmandew
ID: 23715787
net stop mssqlserver
0
 
LVL 1

Expert Comment

by:coderneo
ID: 23715801
you mean the sql service or the client?? please be clear!!
0
 
LVL 60

Assisted Solution

by:chapmandew
chapmandew earned 2000 total points
ID: 23715813
well, that isn't a client service to stop, so it would have to be the server service...
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:BobSpenc
ID: 23715817
Sorry, both.
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 23715828
use this:

net stop mssqlserver
0
 

Accepted Solution

by:
BobSpenc earned 0 total points
ID: 23715838
Thank You.
0
 
LVL 6

Expert Comment

by:fredbfrugle
ID: 23715848
the above will work for full SQL server,  but if you have SQL Express, then you may have to give the "instance" name as part of the command line
NET STOP MSSQL$SQLEXPRESS    (look in services.msc for the service name)
NET STOP MSSQL$BACKUPEXEC    ECT.....
THEN IN REVERSE
NET START MSSQL$instancename
 
-Jim
 
 
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use LFOs to modulate the sound of their Sampler instruments. Click the Modulation tab in Sampler: Choose one (or more) of the three available LFOs, and click the respective button to turn it on: Select a waveform, an LF…
Suggested Courses

864 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