SQL Server Service Failure Recovery

mjs082969
mjs082969 used Ask the Experts™
on
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!

- Michael
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
AneeshDatabase Consultant
Top Expert 2009

Commented:
what if the subsequent restarts fail .. in that case there will be an infinite fails and restarts making the server busy..

Author

Commented:
aneeshattinga,

The service properties allow you to select the action to take on the first, the second, and then any subsequent failures (see attached).  The subsequent failures is definately something to really think about before implementation, but trying to restart once or twice shouldnt have a negative impact on overall system performance... and may actually get the failed service restarted.

Thanks,

- Michael
recovery.JPG
You are right

the first thing you do when SQL SERVER is down is try to start it again .

I say go for it !!

Guy H

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial