You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. You have received instruction from the CIO to implementing transaction log shipping for a database named CK_Data from a server named Certkiller -DB01 to a server named Certkiller -DB02. A Domain.com user named Rory Allen is appointed as a junior technician in the Research and Development department. You inform Rory Allen that CK_Data is 100 GB in size. It is therefore too big to transfer over the network in a reasonable amount of time. You instruct Rory Allen to minimize the impact on the network. Rory Allen needs to accomplish this by initializing the secondary database.
What actions should Rory Allen perform? (Choose all that apply)
A.
It is vital that a complete backup of CK_Data to portable media is performed.
Then he needs to restore the secondary database from that backup.
Thereafter the STANDBY option needs to be specified.
B.
Rory Allen needs to identify the simple recovery model for CK_Data.
C.
Prior to activating the transaction log shipping to the secondary database Rory Allen needs to perform the subsequent statement on the primary server. The statement that Rory Allen needs to perform is:-BACKUP LOG CK_DATA WITH TRUNCATE_ONLY
D.
A partial backup of CK_Data needs to be performed to portable media.
Thereafter a secondary database should be restored from that backup.
Then the RECOVERY option should be identified.
E.
It is important that Rory Allen identifies either the full or the bulk-logged recovery model for CK_Data.
Explanation:
Standby mode is the RESTORE command option Rory Allen needs to use to configure standby servers. In this mode, the secondary database is available for read-only access by users and applications. Log shipping requires that the primary database is configured with the Full or Bulk-Logged recovery model.