Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote -1 down vote favorite

After some manipulations with a SQL Server application a restarting of the SQL Server is required.

If we restart operation system, does this always mean that we restart SQL Server as well (it seems evident that it does, but just in case I ask to be sure)? Or there could be a situation when we should do it explicitely, for example by choosing context menu item "Restart" in SQL Server Configuration Manager?

I.e. could it be necessary for something to restart SQL Server while OS is working?

share|improve this question
wow! badly worded question. What exactly are you asking? – Nick Kavadias Mar 22 '10 at 14:32

1 Answer

up vote 2 down vote accepted

Yes. When the OS restarts everything restarts. Can't run anything if the OS is not running. There can also definitely be times when you would restart SQL without requiring a server reboot. A reconfig that only affects SQL Server and does not do anything with the underlying OS, for example, could require SQL to restart but wouldn't necessarily require a reboot. Setting persistent trace flags is one example.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.