nerdexam
Microsoft

70-282 · Question #359

You work as the network administrator at certways.com. The certways.com network consists of a single Active Directory domain named certways.com. A server named SR03 is configured with Windows Small…

The correct answer is C. First backup the current transaction log. See the full explanation below for the reasoning.

Question

You work as the network administrator at certways.com. The certways.com network consists of a single Active Directory domain named certways.com. A server named SR03 is configured with Windows Small Business Server 2003 Premium Edition. Two disks is contained on the workstation where you installed Windows Small Business Server 2003.On the one disk the SQL database and the other disk the transaction log. Backup have been scheduled to occur on a weekly basis for both disks. A full database backup is completed every Saturday night. The transaction log backups are completed on Monday and Tuesday nights. A hard disk failure occurred one Wednesday night. And you consequently received instructions from the CIO to recover the information. The hard disk that failed contained the database. You thus need to take the necessary steps to recover the information. What should you do?

Options

  • AFirst restore the database backup from Sunday night.
  • BFirst restore the transaction log backup from Tuesday night
  • CFirst backup the current transaction log
  • DFirst backup the current database.

How the community answered

(44 responses)
  • A
    5% (2)
  • B
    7% (3)
  • C
    73% (32)
  • D
    16% (7)

Community Discussion

No community discussion yet for this question.

Full 70-282 Practice