Joan is the Microsoft Project Server administrator for her organization and she has hired you to consult with her about the backup and restore process for her SQL servers. She is worried that her current backup strategy is not accurate for the busy servers she has in her organization. She is currently completing a full backup every three weeks and differential backups daily. What is the immediate danger in Joan’s backup schedule?
A.
Each successive differential database backup is larger than its predecessor, requiring more backup time, space, and restore time.
B.
Each successive differential database backup is smaller than its predecessor, and requires more backup tapes to secure.
C.
Full backups should be done every day to ensure all of the data is backed up.
D.
Full backups should be done more often to ensure that all of the data can be restored.
Explanation:
Differential backups record everything that has changed since the last full backup. The more things change the larger the differential backups will be. In additional, the more tapes that are created the longer the restore process will be in case of a fault.