Differences

This shows you the differences between two versions of the page.

--- en:dbbackup [2021/12/14 15:17] – onyxadmin
+++ en:dbbackup [2023/04/11 15:45] (current) – [Live Backup] onyxadmin
@@ Line 1: / Line 1: @@
+====== Backup Concept======
-====== Backup Concept ======
+<WRAP left nicebox blue>
+Setting up a backup for the data stored on the database server should be done immediately after installing the productive database instance in order to be able to restore all data quickly and completely in case of hardware and software cashes. \\
+The proper implementation and activation of the selected backup concept is the responsibility of the user.
+</WRAP>
 ----
-=====Database Folders =====
+===== Directories to be backed up =====
-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.\\
+All local and global data and settings are located in the Onyx database on the database server in the default installation directory ..\Onyx3Server.\\.
-Alternatively, you can use an external backup program which has the capability to stop and re-start services (in our case: service [[program_onyxdbserver|OnyxDBServer.exe]]) by a script command before resp. after the backup is performed.\\
+If the paths for the database ..\OnyxDB and/or images ..\Pictures were moved to other locations during the installation (e.g. to another partition or to a NAS), then the information in question will be physically located at that location.\\
+In order to back up all relevant data so that it can be restored without loss on the same or on a new computer in the event of a hardware or software problem, there are several backup concepts that should be selected, configured and applied depending on the requirements in the specific facility.\\
+It is recommended to consult an employee qualified in IT matters who has the required knowledge and access rights for a correct setup.\
 \\
+----
+===== File Backup =====
-=====Automatic Backup =====
+During a file backup the directories
-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 [[program_onyx3config|Onyx3Config]] that can be found in program group Onyx3Server on the server PC.\\
+  * ..\OnyxDB and
+  * ..\Pictures
+at their [[:program_onyxdbserver_tab53|configured location]] are copied manually or by means of external backup software completely or differentially to a backup medium. If possible, this should be an external data medium that is also stored outside the facility in order to exclude loss in the event of events such as fire, burglary, etc.\\
+A differential backup is recommended only for the image path, while the database folder should always be copied completely. \\
+{{   :file_backup.png?nolink   }}
+++++Details|
+==== Backup Database Folder====
+Since the NexusDB database used by OnyxCeph³™ is an SQL database, the OnyxDB folder must not be copied as long as the database server OnyxDBServer is running. This must therefore be stopped manually using the Onyx3Config operating program, regardless of whether it was started as a program or service.\\
+{{:stopservice.png?nolink400}}
 \\
-Once [[program_onyxdbserver|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.\\
+After the backup is completed, the database server OnyxDBServer must again be started manually using the Onyx3Config operating program. Alternatively, the restart of the database server can be done by the external backup software if possible.\\
+{{:startservice.png?nolink400}}\\
 \\
-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
-  * {{:icon_folder.png|}} ..\Onyx3Server\Backup
+==== Back up images folder====
-  * {{:icon_folder.png|}} ..\Onyx3Server\Pictures
-by an external backup tool to a mobile hard drive or rev cartridge and store the daily backup drives outside your practice.\\
+The folder(s) ..\Pictures contains all image data and can also be copied while the database program OnyxDBServer is running. The configured image paths can be read out in the user interface of the server program.\\
+{{:selsetdirs.png?nolink500}}\\
 \\
+++++
+----
+===== Live Backup =====
+During a live backup, the directories
-=====Manual Backup =====
+  * ..\Backup and
+  * ..\Pictures
-Open [[program_onyxdbserver|OnyxDBServer]] on tab |Backup/Manual| as described above and start a manual backup by clicking button [Start Backup Now].\\
+are copied to a backup medium at their configured location either manually or differentially using external backup software. If possible, this should be an external data medium that is also stored outside the facility in order to rule out loss in the event of events such as fire, burglary, etc.\\
 \\
-=====Restoring Data =====
+{{   :live_backup.png?nolink   }}
-Open [[program_onyxdbserver|OnyxDBServer]] on tab |Backup/Manual| as described above and start data restore by clicking button [Restore Data].
+++++Details|
+==== Backup database folder====
+Instead of the database folder ..\OnyxDB, the backup folder preconfigured in the [[:program_onyxdbserver|database server program OnyxDBServer]] is backed up during the live backup, which contains a 1:1 copy of the database folder OnyxDB in the format O3B. At which time and with which redundnaz this live copy of the database is created is defined on the [[:program_onyxdbserver_tab71|corresponding tab]] of the [[:program_onyxdbserver|database server program]].
+So during live backup, unlike file backup, the database server OnyxDBServer does not need to be stopped and restarted after the copy operation is complete.\\
+\\
+==== Backup images folder====
+The folder(s) ..\Pictures contains all image data and can be copied even when the database program OnyxDBServer is running. The configured image paths can be read out in the user interface sof the server program.\\
+{{:selsetdirs.png?nolink500}}\\
+\\
+++++
+----
+===== Manual backup =====
+Open the user interface of the database program [[:program_onyxdbserver|OnyxDBServer]] (as described above) and start the manual backup by button click on register [[:program_onyxdbserver_tab71|Manual|]].\\
+\\
+===== Data restore =====
+Open the user interface of the database program [[:program_onyxdbserver_tab71|OnyxDBServer]] (as described above) and start data recovery from an Onyx backup file *.OnB using button click on register |Manual|.
 ^Note ^
-|Data can only be restored if [[program_onyxdbserver|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.|
+|Data recovery can only be performed if the database program has been stopped beforehand. If the images were backed up separately, as recommended above, the backed up image directory //..\Pictures// must be copied back 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. {{:link.png|}} [[moveserver|Moving Onyx-Database Server 3.X]]).|\\
+|The backup file *.OnB can be manually unpacked as an archive by renaming it to *.zip. The archived directories //..\OnyxDB// and //..\Pictures// can be copied into a new installation to perform the data restore manually (see also {{:link.png|}} [[:moveserver|Move Onyx Database Server 3.2]]).|
-===== Deactivate Backup =====
+===== Disable backup =====
-If you back up the server directory daily anyway as part of an external backup process, you should disable the internal backup in the [[program_onyxdbserver_tab74|Settings of the database server]] to save disk space.
+If you back up the server directory daily anyway as part of an external backup, you should disable the internal backup in the [[:program_onyxdbserver_tab74|settings of the database server]] to save disk space.\\