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?
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.