Which of the following solutions would provide the high-availability and enable users to run reports on both copies of the databases?

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 ABCSQL1.

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

View Answer

Answer: A