An Era-managed production MSSQL database crashed during a busy holiday weekend and the administrator has to restore the database to the most recent timestamp with an objective to reduce the restore…

Question

Options

• APerform Restore Source Database by selecting Restore time just before the database crash.
• BPerform Restore Source Database by selecting most recent and include Tail log Backup
• CPerform Restore Source Database by selecting the available snapshot.
• DPerform Restore Source Database by selecting the current time.

• A
  9% (4)
• B
  81% (38)
• C
  4% (2)
• D
  6% (3)

Explanation

Nutanix Era is a database management solution that automates and simplifies database administration tasks such as provisioning, patching, cloning, and backup. In the event of a database crash, the most effective way to minimize data loss and reduce restore time is to perform a restore of the source database by selecting the most recent point in time and including the Tail log Backup. The Tail log Backup includes all the transactions that have occurred since the last transaction log backup, which helps to minimize data loss. By selecting the most recent point in time for the restore, the administrator ensures that the database is restored to the state it was in just before the crash, thereby reducing the amount of data that needs to be reprocessed or reentered. This approach aligns with the Nutanix Era's capabilities and best practices for database recovery.

No community discussion yet for this question.