SQL Server with Mr. Denny

Nov 15 2010   11:00AM GMT

A service restart is a service restart

Denny Cherry Denny Cherry Profile: Denny Cherry

Every once and a while I run across someone who thinks that the way to correctly restart the SQL Server service is to use the SQL Server Configuration Manager.  That’s just not the case.  You can restart the services from SSMS (if your account has rights), or from the service applet in Administrative Tools, or Computer Management, or the NET STOP command shell command, or the sc command shell command, or power shell.

These all have the same effect, to tell the Windows API to issue a stop command to the service which the service takes and uses to shutdown.  None of them are the correct way, as they all do the same thing.

Denny

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: