When considering the backup strategy, one of the main aims should be to reduce the amount of data that has to be backed up on a regular basis. This approach will give the best chance of bringing down the effect of backup on the overnight processing. One must concentrate on backup strategies that are designed around daily data loads. There are data warehouse systems that are not loaded every day, but at greater intervals. Typically these will be loaded weekly at week end or monthly at month end. These cases can be thought of as special cases of the daily load. All the same issues apply to these cases; the database administrator just has more data to load and manage, and typically a weekend rather than an overnight period to fit it in to.