Database Recovery: Number of Backups Required for Database Restoration | SY0-601 Exam Prep

How Many Backups Are Needed for Database Recovery? | SY0-601 Exam Question

Prev Question Next Question

Question

A database backup schedule consists of weekly full backups performed on Saturday at 12:00 a.m.

and daily differential backups also performed at 12:00 a.m.

If the database is restored on Tuesday afternoon, which of the following is the number of individual backups that would need to be applied to complete the database recovery?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

B.

In this scenario, there are two types of backups being performed:

  1. Weekly full backups (performed on Saturday at 12:00 a.m.)
  2. Daily differential backups (also performed at 12:00 a.m.)

If the database needs to be restored on Tuesday afternoon, we need to consider which backups are needed to fully recover the database.

  • Tuesday: We need the most recent backup before the database failure occurred. This would be the Monday night differential backup.
  • Monday: We need the last full backup before the failure occurred, which is the Saturday full backup.
  • Saturday: Since the full backup is from Saturday, we don't need any additional backups from that day.

So, we need two backups to complete the database recovery: the Saturday full backup and the Monday differential backup. Therefore, the correct answer is B. 2.

Prev Question Next Question