nerdexam
Microsoft

70-432 · Question #146

You are managing two SQL Server 2008 computers called SQLTEST1 and SQTEST2, which include a copy of a database named Sales. The database is replicated between SQL1 and SQL2 by using transactional…

The correct answer is D. You should reserve a full database backup on SQL2. Reserve the backup to SQL1. See the full explanation below for the reasoning.

Question

You are managing two SQL Server 2008 computers called SQLTEST1 and SQTEST2, which include a copy of a database named Sales. The database is replicated between SQL1 and SQL2 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 SQLTEST1 becomes corrupted. You are unable to repair the database. The Sales database on SQLTEST2 is unaffected. You need to return the Sales database on SQLTEST1 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?

Options

  • AYou should reserve the most recent full database backup and the whole transaction logs
  • BYou should reserve only the newest transaction log backup.
  • CYou should detach the Sales database on SQL2.
  • DYou should reserve a full database backup on SQL2. Reserve the backup to SQL1.

How the community answered

(48 responses)
  • A
    10% (5)
  • B
    2% (1)
  • C
    4% (2)
  • D
    83% (40)

Community Discussion

No community discussion yet for this question.

Full 70-432 Practice