What disaster recovery technique involves periodically transferring transaction logs to minimize data loss?

What disaster recovery technique involves periodically transferring transaction logs to minimize data loss?

• A. Failover
• B. Log shipping
• C. Hot site
• D. Build documentation

Answer: (B)

Log shipping is a disaster recovery technique that involves the periodic transfer of transaction logs from a primary database to a standby database. This method is employed to ensure that, in the event of a failure or disaster affecting the primary system, the standby can take over with minimal data loss.

By continuously backing up and transferring the transaction logs, any changes made to the primary database are recorded and can be replayed on the standby system. This allows organizations to restore data to a point just before the failure occurred, significantly reducing the window of potential data loss.

The practice of log shipping is particularly effective because it maintains an ongoing synchronization between the primary and secondary databases, allowing for a relatively quick recovery time. As the logs are sent at regular intervals, this technique supports an efficient disaster recovery strategy, particularly in systems that require high availability and data integrity.