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.)
A.
Redirect client computers to the secondary instance.
B.
Back up all databases on the secondary instance.
C.
Copy all log shipping network shares to the secondary instance.
D.
Back up the tail of the transaction log of primary databases by using the WITH NORECOVERY option.
E.
Apply any unapplied transaction log backups in sequence to each secondary database by using the WITH RECOVERY option on the last log.