Data Warehouse Maintenance
Daily Events
| Time | Event | Run Time |
|---|---|---|
| 11:00pm | Load from URR | Approx run time 1 minutes |
| 1:00am | Refresh from PeopleSoft | Approx run time 10 minutes |
| 3:15am | User database back up | |
| 6:00am | Transaction log back up | |
| 5:00pm | System back up | |
Weekly Events
| Time | Event | Run Time |
|---|---|---|
| Sunday at 12:00am | Rebuild user indexes | |
| Sunday at 2:00am | Rebuild system indexes | |
| Sunday at 4:15am | System back up (MSDB) |