Backup and Recovery Policy

Backups

ITAS Central DBA team maintains the backups for the databases we support.

  • Oracle: PROD and DEV databases backed up daily and retained for 14 days.  Archive logs are backed up hourly and retained for 14 days.  QA is backed up daily and retained for 5 days.  Point in time recovery is available in all three environments.
  • SQL Server: PROD databases are backed up daily and transaction logs for databases in FULL recovery mode are backed up hourly.  DEV is backed up daily.  All DEV databases are in SIMPLE recovery mode so no transaction logs are backed up.  QA is not backed up as it should be a representation of either DEV or PROD and can be recovered from one of those environments.  All backups are retained for 14 days.  Point in time recovery is only available for PROD databases that are in FULL recovery mode.  PROD databases in SIMPLE recovery mode and DEV databases can be restored to the most recent backups.
  • MySQL: PROD and NON-PROD are backed up daily and retained for 14 days.  Point in time recovery is available.

Special one off backups can be requested as needed.

Recovery

  • If recovery of a database is needed please submit a request as outlined on the Service Requests page.