Which method of database recovery involves frequent simultaneous copying of the database to maintain two or more complete copies of the database?

Correct option is B

Mirroring is a method of database recovery that involves maintaining multiple copies of the database by frequently copying the data in real-time or near real-time. This ensures that in case of failure, the mirrored copy can be used to restore the database. It is highly effective for disaster recovery and minimizing downtime.
Important Key Points:
1. Mirroring in Databases: Involves real-time replication of a database to ensure data availability and redundancy.
2. Primary Use: Used for high availability and disaster recovery strategies.
3. Advantages: Ensures minimal data loss and quick failover in case of system failure.
Knowledge Booster:
· Rollback: Used to undo changes made during a transaction if an error or issue occurs. It does not involve creating multiple database copies.
· Reprocessing: Refers to re-executing a sequence of operations, typically not related to maintaining copies.
· Rollforward: Involves applying transaction logs to a backup to bring the database to a consistent state, not simultaneous copying.
· Rolling: Not a commonly recognized term in database recovery.