Backup Database
To backup a database, perform one of the following after login to the database.
- Click [Backup Database
] from the toolbar.
- Right-click the database and then select [Backup Database].
- Select [Action] > [Backup Database] on the menu.
The backup operation can be performed even when the database server is running. For details, see "Database Backup" in the CUBRID online manual.

- Database name : The name of the database to backup.
- Volume name : Specifies the name of the backup volume. The default volume name is in the form of [database name_backup_backup level]. However, you can change the name.
- Backup level : Specifies the backup level. Level0 is a full backup, Level1 is a backup that stores changes made only after the Level0 backup. Level2 is a backup that stores changes made only after the level 1 backup.
For example, if there is a backup volume displayed as Level0, the administrator can choose only Level0 or Level1. If there are no previously performed backups, the administrator can choose only Level0.
- Backup directory : Specifies the directory where backup files are to be stored. The default is set to the $CUBRID/databases/[DBNAME]/backup directory.
- Checking consistency of the database : Checks consistency of the database to backup before the backup process. It is recommended to select this option.
- Delete unnecessary log-archives : Deletes unnecessary archive log files while restoring a database. Note that archive log files might be required if database restore does not go well due to backup file errors. When this option is selected while the database is set to the master server in the replication environment, the Maintain replication log option is checked automatically.
- Number thread : Specifies the number of threads to be used concurrently during the database backup. It is recommended to set the maximum number of threads to be the same as the number of CPUs. The default value is 0, in which case the number of threads is automatically determined.
- Compress backup volumes : Compresses the database backup. It is recommended to select this option.
If a backup has been executed for the target database, you can check the backup history from the [Backup History Information] tab. You can also check information such as the backup level, last backup date, size of the backup file, backup file path as well as free space of the disk where the current database volume exists.
