To add to Jason's answer, please check the following documentation for more details:
https://docops.ca.com/ca-spectrum/10-2-2/en/administrating/database-management/spectroserver-database-maintenance/database-backups#DatabaseBackups-ConfigureOnlineBackup
regards
shane
Configure Online Backup
When you configure online backup, you can specify the backup interval and the date and time of the first scheduled backup. For more advanced scheduling options, use the StartOnlineBackup application in the $SPECROOT/SS-Tools directory to initiate online backups. The StartOnlineBackup application can be launched from either the Task Scheduler or the crontab for the host system. The advanced scheduling options in the StartOnlineBackup application can avoid problems where daylight savings time skews scheduled backups.
Follow these steps:
- In OneClick, open the Universe Topology view, and then select the VNM model.
- Click the Information tab, and expand the Online Database Backup subview.
- Configure the following settings as required:
- Automatic Backups
If enabled, online backups are automatically performed with the Online Backup feature according to the time interval specified in the Backup Interval setting. - Backup Interval
Specifies the interval between automatic backups in hours and minutes. We recommend using the default interval of 24 hours and 0 (zero) minutes so that the database is backed up at the same time every day. Enter any value. For example, 168 hours and 0 minutes (for a one-week interval) and 10,080 minutes (also for a one-week interval) are equivalent. - Next Backup Date & Time
Displays the date and time for the next scheduled backup. You can specify a date and time for the first backup. However, subsequent backups are performed at the interval that is specified in the Backup Interval setting. - Backup Compression
If enabled, backup files are compressed using the compression utility before being written to disk. Compressed files are saved with a .gz suffix appended to the filename. If disabled, files are saved uncompressed. The default value is Enabled. - Prefix for Backup File Name
Specifies the user-defined portion of the backup file name. The default prefix is “db_”. However, you can specify any character string that creates a legal file name for the system on which you are running SpectroSERVER. If unset, no prefix is added to the file name.
The filename suffix indicates the date and time when the backup was executed and uses the following format: yyyymmdd_hhmm.SSdb [.gz]
Format | Description |
---|
yyyy | 4-digit year |
MM | month |
dd | day of the month 1 through 31 |
hh | hour of the day - 1 through 24 |
mm | minute - 00 through 59 |
gz | indicates a compressed backup (compressed files only) |
SSdb | default suffix for all database save files |
Backup Directory
Specifies the directory where the backup files are stored. We recommend using a local directory. The default directory is $SPECROOT/SS-DB-Backup.
- Minimum Required Disk Space (MB)
Specifies the minimum disk space that must be available to initiate an online backup. The default threshold value is 20 MB. If an automatic backup is initiated when the available disk space falls below the threshold, a yellow alarm is generated. The probable cause indicates a backup failure due to low disk space.
Click the Begin Backup Now button to initiate a backup on demand using the current settings.
The online database backup utility first pauses SpectroSERVER operations. Then it copies and saves the database.
Note: The status of an in-progress online backup operation is displayed next to the Begin Backup Now button. If an error occurs, an event and an associated alarm are displayed on the Events tab and Alarms tab. For a list of the events and alarms that can be generated during an online backup, see
Online Backup Events and Alarms.