Multiple choice technology web technology

One of your users has discovered some malicious updates to your data that occurred the day before at about 2 P.M. how can you return the database to the state it was in just before the update occurred?

  1. Perform a full database restoration with point-in-time recovery

  2. Perform a differential database restoration with point-in-time recovery

  3. Perform a transaction log restoration with point-in-time recovery

  4. You cannot return the database to the previous state
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

To recover to a specific point in time, you restore the full backup, then the latest differential, then transaction logs up to (but not including) the malicious update time. Transaction log restoration with point-in-time recovery is the correct approach.

Keep practicing — related questions