20. You have a SQL Server 2008 installation, and you want to create a high-
availability solution. What are the ideal approach(es) to solve this problem?
A. Backup and restore
B. Replication
C. Mirroring
D. Clustering
The correct answers are C and D. C and D are automated high-availability
solutions. Answer A is not necessarily a good solution as it is not automated.
Answer B will create a copy of a database, but will require intervention in
order for the replicated database to become the active database.
Bạn đang xem 20. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P141 DOC