Which of the following is NOT a recommended backup and recovery practice?

• A. use multiple backup devices
• B. test backups periodically to make sure data can be restored
• C. perform backups on Wednesdays during peak use
• D. use full backups to minimize the time to restore databases

Answer: (C)

Backups should be scheduled during off-peak hours to minimize performance impact and ensure a stable, consistent snapshot of data. Using multiple backup devices provides redundancy in case one media fails, which protects against data loss. Regularly testing backups by performing restorations confirms that data can be recovered when needed. Full backups can simplify and speed the restore process, especially in environments where rapid recovery is important and storage and time permit it. Doing backups during peak use introduces heavy I/O load when users and applications are actively querying or updating the database, which can degrade performance and risk an inconsistent state during the backup. That practice goes against best-practice goals of reliability and speed of recovery, so it is not recommended.