Hi.

I found this script as an example of a backup-script:
http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=ALTER_JOB

I am just wondering, why it has:  IF (DBName <> 'Configuration')

Should we not also backup the configuration-database?

Eydun


There are two special files in ElevateDB -  EDBConfig.EDBCfg & EDBDatabase.EDBCat. These hold the configuration data and the catalog.The catalog can be included in a backup by adding the INCLUDE CATALOG parameter. The configuration can't.

If you do try and back up the configuration database you'll get


ElevateDB Error #200 This operation cannot be performed on the system database Configuration or any privileges granted to it


Roy Lambert

Eydun,

<< Should we not also backup the configuration-database? >>

ElevateDB still needs functionality for this (backing up the configuration file).  The actual Configuration database is virtual and constructed on-the-fly for the purposes of system information queries.




Tim Young
Elevate Software
www.elevatesoft.com