You have five servers that run Microsoft SQL Server, Each server hosts multiple databases. You plan to implement fault tolerance.
You need lo implement a fault tolerance solution that meets the following requirements:
– Each database must use a separate fault tolerance configuration.
– The solution must support three or more copies of each database.
– Failover of database must be automatic.
What should you do use?
A . Always On availability groups
B . database mirroring
C . transactional replication
D . log shipping
Answer: A
Explanation:
An availability group supports a replicated environment for a discrete set of user databases, known as availability databases. You can create an availability group for high availability (HA) or for read-scale. An HA availability group is a group of databases that fail over together.
Each set of availability database is hosted by an availability replica. Two types of availability replicas exist: a single primary replica. which hosts the primary databases, and one to eight secondary replicas, each of which hosts a set of secondary databases and serves as a potential failover targets for the availability group.
References: https://docs.microsoft.com/en-us/sql/database-engine/availabilitygroups/windows/overview-of-always-on-availability-groups-sql-server?view=sql-server-2017