It is not sufficient simply to check that your backup scripts are backing up the intended files. All the failure scenarios identified above need to be explored, with the suggested recovery path being implemented in full. This will add at least a week to the project test plan, and possibly as much as a month, depending on the size and complexity of the data warehouse.