Start / Stop SQL Server From Command Prompt or Run

[sheem]

Trouble:

Microsoft SQL server is a a service that helps run database related applications to run. How can we run SQL Server through run prompt or command prompt.

*


Let’s see how can we start, stop SQL Server 2005 through run prompts with some simple commands


Fix:

SQL Server 2005 is actually a service running behind, so you can start and stop the instance of SQL Server by starting or stopping the service.

*

1. Open Start Menu >> Run,

*

2. Run the following command to run or stop the SQL Server

*

2.1 To Start SQL Server 2005 – run the following command at run prompt***

net start mssqlservaer

*

2.2 To Stop SQL Server 2005 – run the following command at run prompt***

net stop mssqlserver

*

3. That’s it

*

Note: You can also run these commands through command prompt or store both of these commands in batch file in sequence of stop and start command to restart running SQL Server.

[naz]

v nice shairng