SQL Server stop and restart command

We know that 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

Let's collect 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 cumbersome, the exam, the big hint on the desktop added a cmd file, the contents are as follows: (SQL Server occupies a lot of memory)

net stop iisadmin/y

net start w3svc

net stop MSSQLServer

NET start MSSQLServer

It's convenient to double click the cmd file each time you need to reboot IIS and SQL Server