Backup Automation
When you login to the database, you can view [Backup plan] under [Job automation] in the navigation tree. The [Add Backup Plan] and [Auto Backup Logs] menus will appear when you right-click [Backup plan].

If you want to execute a backup periodically with the CUBRID Manager, configure the values of [Add Backup Plan]. The DBA can configure the backup automation while the Manager server is running. It is not affected by whether the database is running or not. That is, backup automation is executed only when the Manager server is running.
Add Backup Plan

- Backup ID : Enter the name of the backup job. The backup ID must be unique in the database because multiple backup plans may exist in the same database.
- Backup level : You can choose from 0, 1, and 2. Level0 is a full backup. Level1 is the first incremental backup that backs up changes made only after Level0 backup. Level2 is the second incremental backup that backs up changes made only after the Level1 backup.
- Backup path : Specifies the directory of the backup volume.
- Period type : You can select a backup period from options of Monthly, Weekly, Daily and A specific day.
- Period detail : You can set details for the period type you selected.
- Backup hour : Enter the time when the automated backup is to be executed. You must enter the time in hour and minute.
- Options : You can specify an option for backup. For details, see "Database Backup" in the CUBRID online manual.
-
- Store old backup file : This option stores the current original backup volume file of the database in database_directory/backupold directory.
- Delete archive volumes : An option that deletes archive log volumes after backup. When this option is selected while the database is set to master server in the replication environment, volumes do not affect the replication will be deleted automatically.
- Update statistics information : Updates statistics information after backup.
- Checking database consistency : Checks database consistency during backup.
- Use compress : Uses compression during backup.
- Number thread : Specifies the number of threads to be used concurrently during backup. It is recommended to configure the maximum number of threads to be the same as the number of CPUs. The default value is 0. If it is set to the default value, the number of threads is determined automatically by the system.
- Online backup : Automated backup is executed only when the database is running. If the database stopped, only error logs are recorded without backing up the database.
- Offline backup : Automated backup is executed only when the database stopped running. Forces the database to shut down if it is currently running, performs an automated backup, and then restarts the database.
Auto Backup Log
Provides the error logs created during backup automation.

Edit/Delete Backup Plan
Edits backup automation jobs in the same way for adding backup automation, or deletes unnecessary backup automation jobs.
Right-click a desired backup automation in the search tree and then select [Edit Backup Plan], or [Delete Backup Plan].