70-450 · Question #98
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…
The correct answer is A. Redirect client computers to the secondary instance. D. Back up the tail of the transaction log of primary databases by using the WITH E. Apply any unapplied transaction log backups in sequence to each secondary database by. While the maturation of clustering and mirroring in SQL Server 2008, log shipping doesn't see the widespread usage it once did. Jose Baretto's blog has a nice concise explanation of the steps in a log shipping failover. They're out of order in the above question, which can make…
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
How the community answered
(32 responses)- A72% (23)
- B19% (6)
- C9% (3)
Explanation
While the maturation of clustering and mirroring in SQL Server 2008, log shipping doesn't see the widespread usage it once did. Jose Baretto's blog has a nice concise explanation of the steps in a log shipping failover. They're out of order in the above question, which can make thinking through the process a bit more difficult. 1. Backup of the tail of the log on the primary using NORECOVERY (assuming this is possible). 2. Restore that log backup as the final link to the secondary, and specify RECOVERY. 3. Point any applications to the now-restored secondary server.
Topics
Community Discussion
No community discussion yet for this question.