SQL Server on Linux allows organizations to achieve a wide array of service-level agreement goals to accommodate various business requirements.
The simplest solutions leverage virtualization technologies to achieve a high degree of resiliency against host-level failures, fault tolerance against hardware failures, as well as elasticity and resource maximization. These systems can run on-premises, in a private or public cloud, or hybrid environments. The simplest form of disaster recovery and protection is the database backup. Simple solutions available in SQL Server 2017 CTP 2.1 include:
- Resilience against guest and OS level failures
- Unplanned and planned events
- Minimum downtime for patching and upgrades
- RTO in minutes
- Protection against accidental or malicious data corruption
- Disaster recovery protection
- RTO in minutes to hours
Standard high-availability and disaster recovery techniques provide instance-level protection combined with a reliable shared storage infrastructure. For SQL Server 2017 CTP 2.1 standard high-availability includes:
- Failover Cluster
- Instance level protection
- Automatic failure detection and failover
- Resilience against OS and SQL Server failures
- RTO in seconds to minutes
SQL Server 2017 CTP 2.1 on Linux includes virtualization, backup and restore, and failover clusters to support high-availability and disaster recovery.