You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. ABC.com contains two SQL Server 2008 computers named ABC-DB1 and ABC-DB2.
Both of these computers contain a copy of a database named ABC_DB. You are using
transactional replication between ABC-DB1 and ABC-DB2 for ABC_DB. The backups of the
databases are as follows:
•Full backup is performed nightly.
•Transaction log backups are performed hourly.
Furthermore, replication delay is less than one minute. ABC_DB becomes corrupt on ABC-DB1
and its state was rendered irreparable. You need to return ABC_DB on ABC-DB1 and ensure that
minimal amount of data loss while you copy the data from ABC-DB2 and minimize the impact on
the users of these servers.
What steps should you take? (Each correct option is part of the answer. Choose TWO)
A.
Detach ABC_DB on ABC-DB2.
B.
Make a transactional backup on ABC-DB1.
C.
Make a differential backup on ABC-DB1.
D.
Make a full backup on ABC-DB1.
E.
Make a transactional backup on ABC-DB2.
F.
Make a differential backup on ABC-DB2.
G.
Make a full backup on ABC-DB2.
H.
Restore the latest transactional backups on ABC-DB1.
I.
Restore the latest differential backup on ABC-DB1.
J.
Restore the latest full backup on ABC-DB1.
K.
Copy the ABC_DB from ABC-DB2 to ABC-DB1.
L.
Copy the ABC_DB from ABC-DB1 to ABC-DB2.
M.
Only one action is required.
Explanation:
First backup the current database from ABC-DB2 by making a full backup. Restore this backup to
replace the corrupt database on ABC-DB1.