Start and Stop SQL Server Only Through LifeKeeper for Windows

Although much of your administration of the Microsoft SQL Server is done through the Microsoft SQL Enterprise Manager, you derive two distinct benefits from bringing the Microsoft SQL Server in service and out of service using the LifeKeeper for Windows administration options:

1. Consistent view. When LifeKeeper for Windows stops and starts Microsoft SQLServer, it maintains a consistent view of the server on all nodes in the configuration.

2. Configuration details saved. If you change your Microsoft SQL Server configuration, you can stop and start the server through LifeKeeper for Windows or perform a manual switchover and LifeKeeper for Windows automatically replicates the configuration changes on the paired node.

*Note: If you do not use these options to replicate new configuration information on the paired server, the backup server will use old configuration information in a failover situation.

3. Protected Microsoft SQL services should be set to Manual startup mode through the Control Panel “Services” tool.