Which statement about backup and recovery is NOT true?

Which statement about backup and recovery is NOT true?

• A. Use multiple backup devices
• B. Test the 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 to minimize impact on production while ensuring you can recover data when needed. Doing backups during peak usage can slow down database operations, increase contention for resources, and risk incomplete or failed backups, which is why performing backups on Wednesdays during peak use is not true about backup and recovery practices. The other statements align with solid practices: using multiple backup devices provides redundancy and protects against media failure; testing backups periodically verifies that data can actually be restored; and using full backups to minimize restore time gives you a straightforward restore path, since you’re bringing the entire dataset back from a single backup image (though in practice this is often balanced with incremental or differential backups to manage backup windows and storage).

Backups should be scheduled to minimize impact on production while ensuring you can recover data when needed. Doing backups during peak usage can slow down database operations, increase contention for resources, and risk incomplete or failed backups, which is why performing backups on Wednesdays during peak use is not true about backup and recovery practices.

The other statements align with solid practices: using multiple backup devices provides redundancy and protects against media failure; testing backups periodically verifies that data can actually be restored; and using full backups to minimize restore time gives you a straightforward restore path, since you’re bringing the entire dataset back from a single backup image (though in practice this is often balanced with incremental or differential backups to manage backup windows and storage).