You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
Domain.com contains two SQL Server 2008 computers named CERTKILLER-DB1 and CERTKILLER-DB2.
Both of these computers contain a copy of a database named CK_DB.
You are using transactional replication between CERTKILLER-DB1 and CERTKILLER-DB2 for CK_DB.
The backups of the databases are as follows:
* Full backup is performed nightly.
* Transaction log backups are performed hourly.
Furthermore, replication latency is less than two minutes.
One morning CK_DB becomes corrupt on CERTKILLER-DB1 and its state was rendered irreparable.
Fortunately, the database on CERTKILLER-DB2 was not affected.
You need to return CK_DB on CERTKILLER-DB1 and
ensure that minimal amount of data loss impact on the users of these servers.
What should you do?
A.
You should consider reserving only the latest transaction log backup.
B.
You should consider reserving the latest full database backup and the whole transaction logs
made since the past backup could be made.
C.
You should consider detaching CK_DB on CERTKILLER-DB2 and copy CK_DB to
CERTKILLER-DB1, and link the database on both servers.
D.
You should consider reserving a full database backup on CERTKILLER-DB2 and reserve the
backup to CERTKILLER-DB1.