The SIOS Protection Suite Microsoft SQL Server Recovery Kit will monitor and protect the following services:
SQL2008(R2) 2012, 2014, 2016, 2017 or 2019:
| Core Services | Optional Services |
|---|---|
| SQL Server (MSSQLSERVER) | SQL Server Agent |
| SQL Server Reporting Services | |
| Distributed Transaction Coordinator | |
| SQL Server Browser | |
| SQL Server VSS Writer | |
| SQL Server Integration Services | |
| SQL Full-text Filter Daemon Launcher (available starting in SQL Server 2014) | |
| SQL Server Launchpad (available starting in SQL Server 2016) | |
| SQL Server PolyBase Data Movement (available starting in SQL Server 2016) | |
| SQL Server PolyBase Engine (available starting in SQL Server 2016) | |
| SQL Server CEIP service (available starting in SQL Server 2016) |
Note: “SQL Server Integration Services” is only displayed in the list of optional services to protect when this optional SQL feature is installed.
All data files are stored on shared or replicated volumes. Thus, upon detecting a failure, SIOS Protection Suite switches the database along with its associated volumes and IP socket resources to a backup server. Once SIOS Protection Suite switches all dependent resources to the backup server, it starts the Microsoft SQL service and any protected optional services.
Post your comment on this topic.