You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo.
You are experienced in managing databases in an enterprise-level organization,optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security,troubleshooting, deployment and optimization.
A SQL Server 2008 infrastructure should be managed.
Log shipping should be implemented for several databases on three SQL Server instances.
The logs aremigrated 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.