You are the network administrator for Company. You install Microsoft Windows Small Business Server 2003 with Microsoft SQL Server on a network computer. You configure and install the data files by…

Question

Options

• AReplace the failed disk.
• BRestore the full database backup.
• CBack up the current active transaction log.
• DRestore each required transition log in sequence.

• A
  11% (4)
• B
  3% (1)
• C
  78% (29)
• D
  8% (3)

Explanation

Explanation: The transaction log records all changes made to the database and stores enough information to allow any changes to be undone (rolled back) or redone (rolled forward) in the event of a system failure or if it is told to do so by the application (in the case of a rollback command). Physically, the transaction log is a set of files associated with a database at the time the database is created or altered. Modules that perform database updates write log entries that exactly describe the hanges made. Each log entry is labeled with a log sequence number (LSN) that is guaranteed to be unique. All log entries that are part of the same transaction are linked together so that all parts of a transaction can be easily located for both undo activities (as with a rollback) and redo activities (during system recovery). Incorrect answers: A: Replacing the failed disk is not recovering data. B: Since only the disk with the data files failed, you do not need to restore the full database backup. D: It is not necessary to restore the required transaction logs in sequence since all log entries that are part of the same transaction are linked together.

No community discussion yet for this question.