patternsqlMajor
What reasons are there to stop the SQL Server?
Viewed 0 times
thewhataresqlstopreasonsserverthere
Problem
All I've read about is how potentially damaging it is to stop SQL Server because it creates a cold cache and sucks up memory. So why would someone want to stop the SQL Server? If you can provide any links to articles so that I can read more into this I would really appreciate it!
This question was posed by my teacher. Unless it's some trick question, it has me absolutely stumped. His exact question was:
Conduct research using the Internet and learn why someone would want to stop the SQL Server. Explain your answer.
This was in the context of us exploring how to use SQL Server 2008 R2. I'm not sure if he is asking for the obvious answer, or if there is something I'm missing.
This question was posed by my teacher. Unless it's some trick question, it has me absolutely stumped. His exact question was:
Conduct research using the Internet and learn why someone would want to stop the SQL Server. Explain your answer.
This was in the context of us exploring how to use SQL Server 2008 R2. I'm not sure if he is asking for the obvious answer, or if there is something I'm missing.
Solution
Brent listed some invalid reasons for stopping the service, but there are valid reasons too:
- Restart required by a service pack or other update
- Certain configuration changes (e.g. service account change, hardware changes, instant file initialization, this list could go on for weeks)
- In a cluster, a restart to force a failover or applying a rolling patch
- Windows patching
Context
StackExchange Database Administrators Q#160290, answer score: 22
Revisions (0)
No revisions yet.