Administrator Guide : Administering solidDB® : Performing backup and recovery : Configuring and automating backups
  
Configuring and automating backups
Both local and network backup settings can be configured in the solid.ini configuration file. If you want to automate backups, you can initiate the backup using the solidDB® facility for entering timed commands.
The optional configuration settings for local and network backups can be set beforehand in the solid.ini configuration file, except for the synchronized execution, -s option. The following tables show the corresponding ADMIN COMMAND options and parameter settings.
The options entered in ADMIN COMMAND override the corresponding parameter settings.
ADMIN COMMAND 'backup' and solid.ini parameter correspondence for local backups
ADMIN COMMAND 'backup' option
Value
Parameter
dir
backup dir
General.BackupDirectory=backup dir
Default: backup
Corresponding ADMIN COMMAND options and configuration parameters for netbackup
ADMIN COMMAND 'netbackup' option
Value
Parameter
connect
connect str
General.NetBackupConnect=connect str
Default: no default
dir
backup dir
General.NetBackupDirectory=backup dir
Default: no default
netbackup DELETE LOGS
 
General.NetbackupDeleteLog=yes Default: yes
netbackup KEEP LOGS
 
General.NetbackupDeleteLog=no Default: yes
Example: Setting local backup directory with the General.BackupDirectory parameter
1 Define the default backup directory with the General.BackupDirectory parameter.
[General]
BackupDirectory=weekly_backups
2 Start the backup by issuing the following command:
ADMIN COMMAND 'backup'
Automating backups using timed commands
You can automate local backups by using the solidDB® facility for entering timed commands.
To automate backups, use the Srv.At parameter to define the time and location of the backups.
[Srv]
At = [day] [HH:MM] backup [directory], [[day] [HH:MM backup [directory]]
day ::= sun | mon | tue | wed | thu | fri | sat
If you do not specify the location for the backup file with directory, the directory defined with the General.BackupDirectory parameter is used.
Automating daily backups using time commands
The following Srv.At setting starts a backup every day at 1:30 am. To ensure that at least a week old backup is available, the backups are stored in different directories each day.
[Srv]
At=sun 01:30 backup bckup_sun, mon 01:30 backup bckup_mon, tue 01:30 backup bckup_tue,wed 01:30 backup bckup_wed, thu 01:30 backup bckup_thu, fri 01:30 backup bckup_fri, sat 01:30 backup bckup_sat
Related tasks
Entering timed commands
Related reference
General section
Related information
ADMIN COMMAND syntax
See also
Performing backup and recovery