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:
- 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.
- 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.
- Protected Microsoft SQL services should be set to Manual startup mode through the Control Panel “Services” tool.