You work as DBA at AIOTestKing.com. You administer two SQL Server 2005 computers named AIOTestKing A and AIOTestKing B. AIOTestKing A and AIOTestKing B contain a copy of a database named Sales. The database is replicated between AIOTestKing A and AIOTestKing B by using transactional replication. A full backup of each database is performed every night.
Transaction log backups are performed every hour. Replication latency is typically less than two minutes. One afternoon, the Sales database on AIOTestKing A becomes corrupted.
You are unable to repair the database. The Sales database on AIOTestKing B is unaffected.
You need to return the Sales database on AIOTestKing A to normal operation as quickly as possible. You must ensure a minimum loss of data and minimal impact to users of either server. What should you do?
A.
Perform a full database backup on AIOTestKing B. Restore the backup to AIOTestKing A.
B.
Restore the most recent full database backup and all transaction logs made since the full backup was made.
C.
Restore only the most recent transaction log backup.
D.
Detach the Sales database on AIOTestKing B. Copy the database file to AIOTestKing A, and attach the database on both servers.
Explanation:
Detaching the database will not apply to the minimal impact on users as it will be offline during copy. Restoring only the latest transaction log will not give you a working database and restoring last full backup and all transaction logs after that will not apply to the restore normal operations as quickly as possible part of the requirements.