a. Backup of
...
databases
A backup of each Prod DP/DiP is performed every day in the evening, before the global chain of next day.
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 Sandbox applications
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).
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.
Backup files are stored in the folder \\amznfsxpzodrfov.oxo.priv\share\<company>\Backups\Databases\<Env>
Frequency and retention :
| 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 | ||||
b. Backups for project
A process allows to temporarly manage automatic backups of DSCP applicative databases.
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.
Backup files are stored in the folder \\amznfsxpzodrfov.oxo.priv\share\<company>\Backups\Databases\<Env\Projects
The retention period is in days (weekdays & weekends) and is stored in the setting file D:\DynaSys\Batchs\Settings\dscp_settings.ini on the backend server.
SCo :
| Instances | Databases | Backup retention policy | ||
| DEV | TEST | PROD | ||
|---|---|---|---|---|
| DP1 | DYNASYS_DP1 | Last 15 days | ||
| DP2 | DYNASYS_DP2 | |||
| DP3 | DYNASYS_DP3 | Last 15 days | Last 8 days | |
| DiP1 | DYNASYS_DiP1 | Last 15 days | ||
| DiP3 | DYNASYS_DiP3 | Last 15 days | ||
c. One-time backups
At any time a backup of applicative database can be done via the DSCP management console (see chapter 9.2).
Backup files are stored in the folder \\amznfsxpzodrfov.oxo.priv\share\<company>\Backups\Databases\One-time
d. Restore of applicative databases
Restores may be executed from the DSCP management console (see chapter 9.2).