SQL Server options for high availability and disaster recovery
SQL Server has many features that you can put in place to implement a HA/DR solution that will fit your needs. These features include the following:
- Always On Failover Cluster
- Always On Availability Groups
- Database mirroring
- Log shipping
- Replication
In many cases, you will combine more of the features together, as your high availability and disaster recovery needs will overlap. HA/DR does not have to be limited to just one single feature. In complex scenarios, you'll plan for a primary high availability solution and secondary high availability solution that will work as your disaster recovery solution at the same time.
Always On Failover Cluster
An Always On Failover Cluster (FCI) is an instance-level protection mechanism, which is based on top of a Windows Failover Cluster Feature (WFCS). SQL Server instance will be installed across multiple WFCS nodes, where it will appear in the network as a single computer.
All the resources that...