Maintenance Schedules
From Rise: The Vieneo Province
| System | Job | Frequency | Scheduled Time (Central) | Typical Duration | Worst Duration | Status / Notes |
|---|---|---|---|---|---|---|
| SQL Server | SQL Full Backup (Backup.Subplan_1) | Daily | 12:00 AM | 3m 51s | 4m 58s | Primary recovery mechanism for gameplay/player data. Keep daily. |
| SQL Server | Purge Backup History (Purge Backup History.Subplan_1) | Weekly, Sunday | 12:30 AM | 3s | 5s | Negligible impact. |
| SQL Server | Integrity Check (Integrity.Subplan_1 / DBCC CHECKDB) | Weekly, Sunday | 6:00 AM | 14m 02s | 38m 00s | Moved away from Rise maintenance window. |
| SQL Server | syspolicy_purge_history | Daily | 2:00 AM | 18s | 33s | Negligible impact. |
| SQL Server | Windows Bare Metal Backup | Weekly, Sunday | 9:00 PM | 20m | 20m | Reduced from nightly. SQL-native backups handle the main data protection. |
| Rise / Web Server | RiseTVP Maintenance Window | Daily | 2:00 AM–5:00 AM | ~3 hours | ~3 hours | Now largely isolated from other heavy jobs. |
| Rise / Web Server | Windows Bare Metal Backup | Weekly, Sunday | 12:00 PM | 3h 22m | 3h 22m | Reduced from nightly and moved away from the Rise maintenance window. |