How to Remotely Shutdown, Restart or Log Off Windows Server across the network
March 02, 2010
Database administrators often find the need to restart a remote server once they have completed the installation of an SQL Server Service Pack or a Hot fixes or a Windows Monthly Patch etc. In this article we will take a look at SHUTDOWN.EXE command and its usage.
Using Shutdown.EXE Windows Command Using GUI
Click Start -> Run -> Shutdown - I
This will open up Remote Shutdown Dialog as shown in the below snippet. In this dialog box you need to provide the computer name by clicking Add... button and then select any one among the available options for what do you want these computers to do. In this example, I have selected Restart option and have also checked the option to warm users of this action so that they are aware that the server will be rebooted in next 20 seconds. Finally to restart the remote server, click OK.
It is always advised to provide a meaningful comment as this helps to understand at later time why the server was rebooted. You can refer the following Microsoft Link to understand different switches available in SHUTDOWN.EXE command.
Important Note: It is advised to use this utility from a local machine to reboot a remote server.
To know more about latest SQL Server Service Packs, Hot fixes and Patches you can refer the following article Microsoft SQL Server Build Versions
In this article you have seen how easily one can shutdown, restart or log off users using Shutdown.exe command.
Continue Free Learning...
Geeks who read this article also read…
- How to repair a Suspect Database in SQL Server
- Steps to Rebuild System Databases in SQL Server
- Enforce Password Policies and Password Expiration for SQL Server Logins
- Microsoft SQL Server Build Versions
- Auditing SQL Server Logins
- Database Backup Compression Feature In SQL Server 2008
- Read More SQL Server Articles…