The Microsoft SQL Server service can be started by using Microsoft Windows net commands.
To start Sql server
C:\> net start mssqlserver
To stop Sql server
C:\> net stop mssqlserver
To start the default instance of SQL Server from a command prompt
cd \Program Files\Microsoft SQL Server\MSSQL.MSSQLSERVER\MSSQL\Binn\sqlservr.exe
To start the default instance of SQL Server from a command prompt
Press CTRL+BREAK or close the command window.
You can also start, stop it from windows services
1.Go to Run by Start->Run or Win+R
2.Type services.msc, below screen will appear
3. Search for SqlServer(sqlexpress) and stop or start it by right click on it…thats it.
No comments:
Post a Comment