a. Backup of databases
A process allows to manage automatic backups of DSCP databases.
All databases from Dev / Test / Prod environments are concerned by this backup process, meaning applicative, DH, web and system databases.
All backups are generated at 11.30pm CET on the backend server. Then an archiving process runs at 6am to create and/or remove duplicated bak files on the share.
| Instances | Databases | Backup retention policy | ||
| Daily backups | Weekly backups | Monthly backups | ||
|---|---|---|---|---|
| System | master | Last 2 days | Last 2 versions on Sunday evening | Last 2 versions on last day of the month |
| model & msdb | n/a | |||
| DPx | DYNASYS_DPx | Last 2 days | ||
| DPx WEB | DYNASYS_DPx_WEB | |||
| DSCPx | DYNASYS_DSCPx | |||
| DH | dynasys_itf | |||
| DH DSCPx | DYNASYS_ITF_DSCPx | |||
| DH SHARE | ||||
Backup files are stored in the folder \\amznfsxst9udrvf.eua.solvay.com\share\<company>\Backups\Databases\<Env>.
Backup files (DSCP_Dxxx_PROD.bak) are stored on AD21 server and are overwritten each time.
Every 1st of the month, a new generation of monthly backup files (DSCP_Dxxx_PROD_yyyymm01.bak) is created by duplication of daily bak files.
Only backups of the previous and the current month are kept in the archives. The oldest ones are removed automatically. We could enlarge the number of archives but be aware that it could affect disk space.
b. Restore of applicative databases
Sandbox DP/DiP are automatically refreshed from daily Production bak files every Monday morning.
A refresh by application may be deactivated by modifying D:\DynaSys\Sand\Batchs\Dscp_Restore_Auto.cmd (put comments to related lines).
