Proper management of the backup process is a critical step in maintaining the integrity and security of a Teradata system. It helps in verifying that the data warehouse is properly protected against unexpected data loss and data availability is maintained. In addition, it is important to know the requirements for data availability while the backup is in progress, and the impact of resource usage of the backup, both of which can impact performance of other operations during the backup window. It is important to know these requirements at the time the BAR solution is designed, to ensure that the solution that is provided will meet the needs of the customer. The BAR window should not be exceeding the time given to it, or else other users or jobs on the system could be hampered.
When designing the BAR solution, the first requirement that should be considered is the frequency at which backups will be executing. This defines your recovery point objective, or the point at which...