A service restart is a service restart

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

Share

Share on facebook
Share on twitter
Share on linkedin

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Trust DCAC with your data

Your data systems may be treading water today, but are they prepared for the next phase of your business growth?