70-450 · Question #58
You administer SQL Server 2008 servers on a single site. The site contains the following two SQL Server 2008 instances: - An Enterprise Edition server on a server that has a redundant array of…
The correct answer is A. Replication B. Log shipping. Snapshots are not a high availability solution no matter how many times they are included in questions about high availability. Failover Clustering would require the addition of a shared storage array. That leaves log shipping and replication. Log shipping is the weakest of…
Question
You administer SQL Server 2008 servers on a single site. The site contains the following two SQL Server 2008 instances:
- An Enterprise Edition server on a server that has a redundant array
of independent disks (RAID) 10 disk system
- A Standard Edition server on a server that has a RAID 5 disk system
Each instance hosts a single application. You need to recommend a high-availability solution for the site to meet the following business requirements:
- The solution can be implemented on the existing systems.
- The database is available with minimal downtime.
- Data loss is minimal.
- There is minimal effect on the existing system.
What are two possible ways to achieve this goal? (Each correct answer presents a complete solution.
Options
- AReplication
- BLog shipping
- CFailover clustering
- DDatabase snapshot
How the community answered
(32 responses)- A84% (27)
- C6% (2)
- D9% (3)
Explanation
Snapshots are not a high availability solution no matter how many times they are included in questions about high availability. Failover Clustering would require the addition of a shared storage array. That leaves log shipping and replication. Log shipping is the weakest of high availability options in SQL Server 2008. Peer-to-peer replication is viable.
Topics
Community Discussion
No community discussion yet for this question.