December 10, 2009 at 9:50 am
We have a stand alone database server with SQL Server 2008. The server has an attached drive cage. There is a memory issue with the server that will require troubleshooting. The server will probably be rebooted mulitple times. Should I set all of the SQL Services to manual to keep the database engine and SQL services from trying to start and stop multiple times?
December 11, 2009 at 6:43 am
Doesn't really matter as the the SQL Server services will start and stop gracefully. The difference is that you will get faster reboots if you don't have all the SQL Server services starting at each reboot.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 11, 2009 at 6:53 am
As Jack has mentioned, it does not require.
Unless there are jobs that may start depending on their schedule OR other apps or users connecting to it and start some processing, you don't need SQL startup to be set as manual.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply