nerdexam
Symantec

250-318 · Question #58

An administrator is restoring Microsoft SQL database and transaction logs from multiple backup sets. Which option must be enabled in the restore job property for successful manual recovery of the…

The correct answer is C. leave the database nonoperational; additional transactional logs or differential backups can. See the full explanation below for the reasoning.

Question

An administrator is restoring Microsoft SQL database and transaction logs from multiple backup sets. Which option must be enabled in the restore job property for successful manual recovery of the transaction logs?

Options

  • Aallow recovery of additional transaction logs and differential backups
  • Ballow recovery of transaction logs and differential from multiple backup sets
  • Cleave the database nonoperational; additional transactional logs or differential backups can
  • Dleave the database nonoperational; additional transaction log and incremental backups can

How the community answered

(35 responses)
  • A
    17% (6)
  • B
    6% (2)
  • C
    71% (25)
  • D
    6% (2)

Community Discussion

No community discussion yet for this question.

Full 250-318 Practice