You can initiate a local backup by entering the following command in solsql:
ADMIN COMMAND 'backup [-s] [dir backup_dir]'
Available options for the backup command:
Option
Description
-s
Synchronized execution. The call returns either when the backup is completed or due to an error.
dir
backup_dir is the path to the backup directory in the local file system.
If the backup directory is not specified in the command, the directory must be specified in the solid.ini file by using the General.BackupDirectory parameter, see General section.
If two databases are copied to the same directory, the earlier is overwritten by the latter. The backup directory must be different for each database. Moreover, although database files can be stored to different directories and partitions at the source server, they all are copied to the same backup directory. Therefore, identically named database files will conflict in the backup directory. As a consequence, only the most recent backup file among the identically named files has a backup copy in the backup directory.
Note Ideally, ensure that the source and backup directories are on different physical devices and in different file systems. Then, if one disk drive is damaged, you lose either your database files or backup files but not both. Similarly, if one file system fails, either the backup files or the database files survive.