You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2
instance. The SQL Server 2008 instance contains a database, named ABC_Prod, which is
configured in single-user mode. You have configured a backup strategy for ABC_Prod as
described below:
•ABC_Prod is backed up to a file, called ABC_Prod.bak, which is performed at 9 PM every day.
•The transaction log is backed up to a file, called ABC_Prod_HHMM.trn, which is executed at 20
minute intervals starting at 09:20 AM.
You receive a report from a ABC.com user, named Mia Hamm, that certain information was
removed by a search which was executed at 09:40 AM.
You are then instructed to ensure that you recover ABC_Prod to its previous status.
Which of the following actions should you take? (Choose all that apply.)
A.
You should consider restoring the ABC_Prod.bak file using the RESTORE DATABASE
Transact-SQL statement with the NORECOVERY argument.
B.
You should consider restoring the ABC_Prod.bak file using the RESTORE DATABASE
Transact-SQL statement with the RECOVERY argument.
C.
You should consider restoring the relevant ABC_Prod_HHMM.trn file using the RESTORE
DATABASE Transact-SQL statement with the NORECOVERY argument.
D.
You should consider restoring the relevant ABC_Prod_HHMM.trn file using the RESTORE
DATABASE Transact-SQL statement with the RECOVERY argument.
Explanation: