Windows Service Recovery Tab

Hi,

If you check the properties for any service in services mmc (start -->
control panel --> administrative tools --> services) there is a tab
called "Recovery" where one can specify the action needs to be taken
in case of service fails.

This recovery option works very well if service is up and running and
it has failed due to some reason. But think about the scenario where
machine is re-booted and as service is set to automatic it will try to
start but it is not able to start (may be because of network glitch or
what ever reason) and it never tries to start the service again
(though i have specified the recovery options).

Can someone confirm me whether this recovery option works only if
service is already running or it should work for 1st startup as
well???
Is there any way we can configure the service in a way that it re-
tries to start even if its 1st attempt to start the service?

I’m asking this because i have a service which talks to remote
database and we encountered the issue when application machine was
rebooted and service tried to start it couldn't because it was not
able to talk to SQL server (network glitch) and sql server was
available within few minutes but service never re-tried and we have to
start it manually.

Any help on this will be much appreciated.

Thanks in advance.

Cheers,
Manan