What is the BEST backup strategy for a large database with data supporting online sales?
A.
Weekly full backup with daily incremental backup
B.
Daily full backup
C.
Clustered servers
D.
Mirrored hard disks
Explanation:
Weekly full backup and daily incremental backup is the best backup strategy; it ensures the ability to recover
the database and yet reduces the daily backup time requirements. A full backup normally requires a couple of
hours, and therefore it can be impractical to conduct a full backup every day. Clustered servers provide a
redundant processing capability, but are not a backup. Mirrored hard disks will not help in case of disaster.