[OnyxCeph³™ Wiki]

DokuWiki - World Wide Web

User Tools

Site Tools


en:dbbackup

This is an old revision of the document!


Backup Concept

Database Folders

All local and global data and settings are saved in the Onyx database on the server in folder ..\Onyx3Server. However, to backup these data, it is not possible to copy this folder on runtime since there are open tables of the SQL database program in subfolder ..\Onyx3Server\OnyxDB. For this reason, use the OnyxDBServer-internal backup tool.
Alternatively, you can use an external backup program which has the capability to stop and re-start services (in our case: service OnyxDBServer.exe) by a script command before resp. after the backup is performed.

Automatic Backup

To configure the backup settings, you need to launch the SQL database program OnyxDBServer (which usually runs as a service) as a program by means of the server control tool Onyx3Config that can be found in program group Onyx3Server on the server PC.

Once Onyx3Server is launched as a program, the application will be minimized to an icon in the system tray of the Windows task bar and can be opened by doubleclick or contextmenu there. Open tab |Backup| and customize the backup setting for each day of the week. Please, be aware that including Pictures in the backup may increase the required size for the backup file and also backup duration significantly, depending on the amount and the file size of the images.

Recommended: Backup [only] Onyx database in folder OnyxDB into the Backup folder each day at a defined time t1 using the internal backup tool. Thereafter, at time t2, save both folders

  • ..\Onyx3Server\Backup
  • ..\Onyx3Server\Pictures

by an external backup tool to a mobile hard drive or rev cartridge and store the daily backup drives outside your practice.

Manual Backup

Open OnyxDBServer on tab |Backup/Manual| as described above and start a manual backup by clicking button [Start Backup Now].

Restoring Data

Open OnyxDBServer on tab |Backup/Manual| as described above and start data restore by clicking button [Restore Data].

Note
Data can only be restored if OnyxDBServer is stopped. If the backup of folder ..\Pictures was done manually as recomended, image folder ..\\pictures also needs to be restored manually before restarting the database program.
Backup file *.OnB can also be renamed to *.zip and unzipped manually. Archived folder/s ..\OnyxDB and ..\Pictures can be copied on a clean (new) installation to perform a manual database restore (s.a. Moving Onyx-Database Server 3.X).
This website uses cookies. By using the website, you agree with storing cookies on your computer. Also you acknowledge that you have read and understand our Privacy Policy. If you do not agree leave the website.More information about cookies
en/dbbackup.1452933684.txt.gz · Last modified: 2016/01/16 09:41 by onyxadmin