Microsoft
70-450 · Question #98
70-450 Question #98: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #98. The question stem and answer options stay visible for context.
Question
You administer a SQL Server 2008 infrastructure. You implement log shipping for several databases on three SQL Server instances. The logs are shipped to a fourth SQL Server instance. You plan a manual failover. You need to ensure that the database applications use the secondary server after failover. You also need to ensure that users can access the most recent data. Which three tasks should you perform? (Each correct answer presents part of the solution. Choose three.)
Options
- ARedirect client computers to the secondary instance.
- BBack up all databases on the secondary instance.
- CCopy all log shipping network shares to the secondary instance.
- DBack up the tail of the transaction log of primary databases by using the WITH
- EApply any unapplied transaction log backups in sequence to each secondary database by
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.