You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 20 Next »

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.

Backup files are stored in the folder \\amznfsxst9udrvf.eua.solvay.com\share\<company>\Backups\Databases\<Env>.


Frequency and retention :

InstancesDatabasesBackup retention policy
Daily backupsWeekly backupsMonthly backups
SystemmasterLast 2 days

Last 2 versions

on Sunday evening





Last 2 versions

on last day of the month

model & msdbn/a
DPxDYNASYS_DPx

Last 2 days

DPx WEBDYNASYS_DPx_WEB
DSCPxDYNASYS_DSCPx
DHdynasys_itf
DH DSCPxDYNASYS_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 \\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 :

InstancesDatabasesBackup retention policy
DEVTESTPROD
DP1DYNASYS_DP1




DP2DYNASYS_DP2


DP3DYNASYS_DP3

Last 2 days
DiP1DYNASYS_DiP1


DiP3DYNASYS_DiP3


DSCP2DYNASYS_DSCP2


ECo:

InstancesDatabasesBackup retention policy
DEVTESTPROD
DP4DYNASYS_DP4




DP5DYNASYS_DP5


DiP4DYNASYS_DiP4


DiP5DYNASYS_DiP5


DSCP1DYNASYS_DSCP1


c. Restore of applicative databases

See chapter 9.2






  • No labels