You administer SQL Server 2008 instances at three sites.
All sites share a mission-critical database. The business requirements specify that users at each site must
be able to perform the following tasks:
Access and modify data on all sites with minimal latency.
Minimize data loss in the event of a server failure.
You need to provide a high-availability solution that meets the business requirements.
Which solution should you implement?
A.
Failover clustering
B.
Peer-to-Peer replication
C.
Asynchronous database mirroring without a witness server
D.
Log shipping to servers at two of the sites to provide read-only copies of data