You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft
SQL Server 2012 infrastructure. A server named ABC-SQL1 hosts multiple databases that are accessed using
OLTP (Online Transaction Processing) applications. You are concerned about the lack of redundancy provided
by this single server solution.
You want to configure a solution that ensures high-availability for the databases while minimizing costs. You
need to ensure that the databases remain online in the event of a hardware failure of ABC-SQL1. You configure
a second server named ABC-SQL2 and install SQL Server 2012. Which of the following solutions would
provide the high-availability and enable users to run reports on both copies of the databases?
A.
AlwaysOn availability groups
B.
A failover cluster
C.
Database mirroring
D.
Transaction log shipping