SQL Server stop and restart command

We know that the restart of sqlserver is divided into two steps: 1. Stop netstopmssqlserver2, restart netstartmssqlserver3, and add mysql to stop. Start the command netstopmysqlnetstopmysql to add this page. You will not forget to restart sqlserver frequently in WEB development.

We know that SQL server restarts in two steps: 1. stop net stop mssqlserver 2. Restart net start mssqlserver 3. Supplement mysql to stop, start the net stop mysql command to add this page to your favorites. You will not forget to restart SQL server in WEB development.

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.