QuestionQ18

VerifiedPerform DR and Data Protection in a Multicloud Environment

A database server has a corrupt database after its VM was restored from a recovery point. The database VM belongs to the VIP_VMS category, which is protected by a Protection Policy using an asynchronous schedule.

After verifying the status of the NGT tools, an administrator is reviewing the Protection Policy configuration to determine the root cause of the database corruption.

What is the most probable cause?

Explanation

Recovery points can be taken as either crash-consistent (default, disk-only state) or application-consistent (captures in-memory data and in-flight transactions via NGT/VSS quiescing). Database workloads require application-consistent recovery points to ensure all transactions are properly flushed and the database engine's files are in a consistent, recoverable state. If the 'Take App-Consistent Recovery Point' option is not enabled in the Protection Policy, only crash-consistent snapshots are captured, which can result in a corrupted or inconsistent database when restored, even though NGT itself is installed and functioning correctly on the VM.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!