Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Which DBs needing a backup?

Hello experts,

which DBs of ASE (model, saptempdb, ...) do we also have to backup excepting to the <SID>-DB?

Is there a guideline, which db is including what or which db needs to be available in case of an restore?

(worst case restore, starting from scratch)

Kind regards

Former Member
replied

Hi Christian,

You only need to do backup of the databases listed in the SAP Note 1585981:

-> the SID database, because it is the database that contains your data

-> the Master, because it contains the main dataserver structure information (devices, databases, logins, roles, etc) and you cannot start an ASE without this database

-> the sybsystemprocs, because it contains the system stored procedures

-> the sybmgmtdb, because it is the Job Scheduler database

-> the saptools, because it is the DBA Cockpit database

The model is just a template, used when a new database is created, it doesn't contain relevant data.

And the temporary databases are recreated at ASE start. You are not supposed to store there data you would like permanent.

Regards,

Cris

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question