Which DBs needing a backup?
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)
Maria-Cristina NORMAND replied
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.