Is there any reason why one should not change the "Recovery" options for the SQL Server service? It appears that the default action for all failures is "Take No Action". Is there any reason why that after the first service failure the service cannot be restarted?
As I type this I wonder if not every failure is a catastrophic service ending failure. If a minor error could trigger a restart, I could see why this should be avoided.
Thanks In Advance!