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 SIOS Protection Suite administration options:
- Consistent view. When SIOS Protection Suite 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 SIOS Protection Suite or perform a manual switchover and SIOS Protection Suite 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.