An administrator needs to restore a source database from a point in time at 21:50, but the restore option is not available. What could explain the matter?

Question

Exhibit

Options

• APoint in time must be within the most recent range.
• BSelected Restore time is not available.
• CChange to snapshot option.
• DLogs to Backup must be run first.

• A
  7% (3)
• B
  13% (6)
• C
  4% (2)
• D
  76% (35)

Explanation

The provided exhibit shows the NDB Time Machine restore interface for October 31, 2024, with a Point-in-Time (PIT) restore option selected at 21:50. However, the restore option is unavailable, as indicated by the question. The exhibit includes a warning: "Logs to Backup: The database may contain additional logs. Backup any remaining logs before restore or they will be lost." This suggests that PIT restore requires continuous log retention, and if logs since the last snapshot (at 01:10:00) are not backed up, the restore to 21:50 cannot proceed. Running the "Logs to Backup" operation ensures all transaction logs are captured, enabling PIT restore by allowing NDB to replay logs to the desired point.

No community discussion yet for this question.