You are a professional level SQL Sever 2008 Database Administrator. Log shipping should
be implemented for several databases on three SQL Server instances. The logs are
migrated to a fourth SQL Server instance. A manual failover will be implemented. You need
to ensure that the database applications utilize the secondary server after failover. Since
you are the technical support, you are required to confirm that the latest data should be
available to users. Which actions should you perform to achieve the goal? (Choose more
than one)
A.
To achieve the goal, you should utilize the WITH RECOVERY option on the last log to
apply any unapplied transaction log backups in sequence to each secondary database.
B.
To achieve the goal, you should redirect client computers to the secondary instance.
C.
To achieve the goal, you should replicate all log shipping network shares to the
secondary instance.
D.
To achieve the goal, you should utilize the WITH NORECOVERY option to back up the
tail of the transaction log of primary databases.
E.
To achieve the goal, you should back up all databases on the secondary instance.
Explanation: