*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
Establish DB revert procedure. Initiating request and subsequent restoration from back-up.
PatH has access to last 7 calendar days of backups.
- Backups are made for each course.
- Backups are made around noon (morning data changes) and at the end of the day (afternoon data changes). For each course.
- Each backup's name contains a date and time-stamp.
- Files are located on Instruction's file share (R:\ drive)Likelihood of needing to do this is reduced because Pat and others can run recent clone of production DB (from backup) and test on own desktop first.
PatH can do any restore herself using FMPro.
- Zero this herself by: Zeroing out course data on the A&S FMPro server.
- Importing data from the correct course backup file.
- Latest version backup (latest would be from ~half a work day before.
- If PatH needs backup data older than what she has access to herself (> 7 days!, so rare), then she must contact Dani or Tu for them to get via back-ups of the SQL server data (or from EZ-Backup).
- Note that A&S's EZ-Backup would itself only have the 3 prior versions. If course DB was changed each day, that's just three backups. If course DB rarely changed, then that can be a long time.
...