Which statement best describes what happens when a 3rd-party backup tool is chosen to manage log backups for Microsoft SQL in NDB?

Question

Options

• AIf exclusive log access is not granted to NDB, the Point-in-Time (PIT) recovery will not be
• BThird-party backups vendors can continue to backup the archived logs from the database log
• CIf exclusive log access is not granted to NDB, the Point-in-Time (PIT) recovery will be supported,
• DThird-party backups vendors can continue to backup the binary logs from the binary log location.

• A
  6% (2)
• B
  81% (25)
• C
  10% (3)
• D
  3% (1)

Explanation

NDB supports two modes of log backup management for Microsoft SQL databases: NDB- managed and 3rd-party managed. In the NDB-managed mode, NDB takes full control of the log backups and stores them in the Cerebro log location. In the 3rd-party managed mode, NDB allows the use of external backup tools to backup the logs from the database log destination. However, NDB still needs to capture the logs for its own operations, such as point-in-time recovery, clone refresh, and log catch-up. Therefore, NDB will periodically scan the database log destination and copy the logs to the Cerebro log location. This process requires that the log catch-up begins before the logs get backed up by the 3rd-party tool, otherwise NDB will miss some logs and the operations will fail. If the 3rd-party tool grants exclusive access to the logs, then NDB will not be able to capture them at all, and the operations will not be supported.

No community discussion yet for this question.