Proper Way to Stop and Start SQL Server Services?

Question

I was in a course last year where the instructor said that the only proper way to stop and start the various SQL Server services was via the SQL Server Configuration Manager.  Is there any truth to this because I haven't found anything on-line that supports this instructor's statement.

Thanks,

Blaine

Answer 1

Blaine,

Best practice is to use SQL Server Configuration Manager when changing passwords or service accounts, adding trace flags, or in general manipulating the services or configuration.

Having said that, if you needed to script the start and stop of the services I haven't seen anything that says you can't do it that way or that it would hurt it. I also haven't seen any information that says using the net commands does anything of the sort either.

-Sean

 

 

Answer 2

Hi Sean,

Thank you.  Your response confirms my research.

Blaine