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.
Backup files are stored in the folder \\amznfsxst9udrvf.eua.solvay.com\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 | ||||
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 \\amznfsxst9udrvf.eua.solvay.com\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 | ||
| DSCP2 | DYNASYS_DSCP2 | |||
ECo :
| Instances | Databases | Backup retention policy | ||
| DEV | TEST | PROD | ||
|---|---|---|---|---|
| DP4 | DYNASYS_DP4 | |||
| DP5 | DYNASYS_DP5 | |||
| DiP4 | DYNASYS_DiP4 | |||
| DiP5 | DYNASYS_DiP5 | |||
| DSCP1 | DYNASYS_DSCP1 | |||
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 \\amznfsxst9udrvf.eua.solvay.com\share\<company>\Backups\Databases\One-time
Restores may be executed from the DSCP management console (see chapter 9.2).