What is the BEST backup strategy for a large database with data supporting online sales?
Weekly full backup with daily incremental backup
Daily full backup
Mirrored hard disks
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 beimpractical 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.