You work as a database administrator at ABC.com. ABC.com makes use of a SQL Server 2008
R2 instance.
ABC.com has a database, named ABCSales, which has a primary filegroup that includes the OnLine Transaction Processing (OLTP) data. ABCSales also has another filegroup, named
ABCSalesHistory, which hosts antiquated records for the database. These two filegroups are
located on separate drives, while the transaction log for ABCSales is located on a different drive
altogether.
ABC.com’s business hours are from 8 Am to 5 PM. You have configured an archiving solution that
allows for the constant relocation of information from the primary filegroup to ABCSalesHistory.
You have also configured a backup solution that backs up the primary filegroup every 2 hours,
starting at 9 AM and ending at 5 PM. The backup solution includes a daily backup of the
ABCSalesHistory filegroup at 5 PM, and an hourly backup of the transaction log.
When the drive that hosts the ABCSalesHistory filegroup becomes corrupt during the day, you are
instructed to perform a restore procedure that allows for as little records as possible to be lost. The
speed of the restore procedure should also be as fast as possible.
You start by manually backing up the transaction log.
Which two of the following actions should you take NEXT? (Choose two.)
A.
You should consider restoring a differential backup of the ABCSales database.
B.
You should consider restoring the previous day’s backup of ABCSalesHistory.
C.
You should consider restoring a full backup of the ABCSales database.
D.
You should consider restoring the transaction log backups that occurred subsequent to the
previous day’s backup of ABCSalesHistory.
Explanation: