In this post we will discuss how to restart sql server by using Sql Server Management studio (SSMS) 2014, 2012, 2008 and 2005. To restart it, follow following steps:
Sept 1: Right click on sql server instance and choose restart option as shown in the following screenshot:
|SQL SERVER Restart USING SSMS|
Steps 2: After few seconds a confirmation dialog box will appear up. Click on Yes button.
|Sql Server Restart Confirmation Dialog|
Step 3: Sql Server restart will be in process:
It may take around one minute. After some completion of process bar server will be start once again.
Note: Don't click on Close button.