Before rebooting the server, check if any users are currently logged into the database. If users are still logged in, have them exit and sign out of the program.
 

If the server is a Web server, consider rebooting at a time when there will be few or no users accessing the website. It is considered good practice to provide warnings of upcoming outages on the affected Web pages or other website pages which link to the server's website.

If there are other applications running on the server, or other databases using the same SQL Server instance, have all users exit those applications as well.

Note: The service for the SQL Server database can be left running since this will be shut down and restarted with the server (if set to Automatic).

To change it to automatic:

  1. Click Start, Run from your task bar.
  2. Enter services.msc.
  3. Browse for SQL server.
  4. Right-click SQL Server and select Properties.
  5. Select Automatic for the Startup type.


 

Rebooting:

  1. Close all programs
  2. Click Start, Shut Down on the task bar
  3. Choose Restart
  4. Click OK