Jun 30, 2014

Restart Sql Server Using Sql Server Management studio (SSMS)

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:

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:
SSMS Qql Server Restart Processing
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. 

No comments: