SQL server stop and restart commands

We know that SQL server restarts in two steps

1. Stop

Net stop mssqlserver

2. Restart

Net start mssqlserver

3. Add mysql to stop and start the command.

Net stop mysql

Net stop mysql

Add this page to favorites. You won't forget it next time.

In WEB development, you often need to restart SQL server. It is very troublesome to open SQL server every time. The examination prompts you to add a CMD file on the desktop, the content is as follows: (SQL Server occupies a lot of memory)

Net stop iisadmin/y

Net start w3svc

Net stop mssqlserver

Net start mssqlserver

You can simply double-click the CMD file every time you need to restart IIS and SQL Server.