You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. CK_Prod need to be backed up completely.
The transaction log for CK_Prod runs from 08:00 to 17:00, in two hour intervals.
The database snapshot needs to be done daily at 07:00.
A Domain.com user named Mia Hamm has removed all the information on CK_Prod which was
entered into the CurrentSpeaker table the previous day. Deletion is the first step for the database.
However, later in the day many other changes in CK_Prod have been effected.
You received instructions to run a full backup on CK_Prod despite all these problems.
What should you do?
A.
You should consider reserving the Full Backup of the previous night and all transaction log
backups until the 10:00 backup.
Then you should use the STOP AT statement on some of the restores.
B.
You should consider using the Delete subquery in the INSERT statement to transfer the deleted
rows from the morning’s database before the snapshot to the CurrentSpeaker.
C.
You should consider reserving the Full Backup and all transaction log backups until the 10:00 backup.
Then you should use the STOP AT statement on the last restore.
D.
You should consider using the SELECT subquery in the INSERT statement to move the
deleted rows from this morning’s database snapshot to the CurrentSpeaker table.