SQL Server stop and restart commands

Http://www.ynpxrz.com/n822732c2024.aspx

We know: SQL Server restart is divided into two steps.

1. Stop

net stop MSSQLServer

2. Restart

NET start MSSQLServer

3. Add MySQL stop, start command

net stop MySQL

net stop MySQL

Bookmark this page. You won't forget it next time.

In web development often need to restart SQL Server, every time you open SQL Server to operate very troublesome, exam, big tips added a cmd file on the desktop, the content is as follows: (SQL Server takes up a lot of memory)

net stop iisadmin/y

net start w3svc

net stop MSSQLServer

NET start MSSQLServer

It is convenient to double-click the cmd file every time you need to restart IIS and SQL Server.

SQL Server stop and restart commands