Which backup scheme reduces the amount of downtime to perform a restore but creates additional IT management and physical resource overhead?
A)Full database backup plus differential database backup plus multiple transaction log backups
B)Single transaction log backup plus full database backup
C)Full database backup plus multiple transaction log backups
D)Single transaction log backup plus simple recovery model

Question

Quizplus · Accepted Answer

Option A involves a full database backup, differential backups, and multiple transaction log backups. This approach minimizes downtime during a restore because you can restore the full backup, apply the latest differential backup, and then apply the necessary transaction log backups up to the point of failure. However, it requires more management and resources because you need to manage multiple types of backups and ensure that they are all correctly synchronized and stored.

Which Backup Scheme Reduces the Amount of Downtime to Perform