You work as a database administrator at ABC.com. ABC.com makes use of a SQL Server 2008
R2.
ABC.com has two servers, named ABC-SR13 and ABC-SR14, which has SQL Server 2008 R2
installed. Both of these servers hosts a copy of a database, named ABCProducts. You have
configured transactional replication for ABCProducts between ABC-SR13 and ABC-SR14 with a
latency of 1 minute. You have also configure a backup strategy for ABCProducts as follows:
•A daily full backup after business hours.
•Transaction log backups every 30 minutes during business hours.
When ABCProducts on ABC-SR14 fails and cannot fix it, you verify that the ABCProducts
database located on ABC-SR13 is operating as normal.
You are then instructed to restore the ABCProducts database on ABC-SR14 with the least
possible data loss, in the shortest amount of time. The process should also have the least effect
on users of ABC-SR13 and ABC-SR14.
Which of the following actions should you take?
A.
You should consider running a differential database backup of ABCProducts on ABC-SR13,
and restoring it on ABC-SR14.
B.
You should consider running an incremental database backup of ABCProducts on ABC-SR13,
and restoring it on ABC-SR14.
C.
You should consider running a snapshot database backup of ABCProducts on ABC-SR13, and
restoring it on ABC-SR14.
D.
You should consider running a full database backup of ABCProducts on ABC-SR13, and
restoring it on ABC-SR14.
Explanation: