You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2
instance that contains a database named ABC_Prod.
The transaction log for ABC_Prod runs from 7 AM to 4 PM at 1 hour intervals. You have
configured a snapshot of the database to be taken daily at 6 AM.
A ABC.com user, named Mia Hamm, starts her day everyday by removing all ABC_Prod data that
was entered into the ExistingSpeaker table the previous day. Numerous other changes have since
been made to ABC_Prod.
You have received instructions to run a full back up on ABC_Prod despite all these problems.
Which of the following actions should you take?
A.
You should consider restoring the previous day’s backup before running the full backup
B.
You should consider restoring the required data from the first transaction log for the day.
C.
You should consider running the system restore procedure.
D.
You should consider moving the deleted data from this morning’s database snapshot to the
ExistingSpeaker table via the SELECT subquery in the INSERT statement.
Explanation: