PrepAway - Latest Free Exam Questions & Answers

Which three tasks should you perform?

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.)

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply