en:dbbackup
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
en:dbbackup [2015/10/29 13:47] – onyxadmin | en:dbbackup [2023/04/11 15:45] (current) – [Live Backup] onyxadmin | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ~~NOTOC~~ | + | ====== Backup |
- | ===== Backup-Konzept | + | <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. | ||
+ | </ | ||
---- | ---- | ||
- | | [[dbbackup# | + | ===== Directories to be backed up ===== |
- | | [[dbbackup# | + | |
- | | [[dbbackup# | + | |
- | | [[dbbackup# | + | |
- | ==== Database | + | All local and global data and settings are located in the Onyx database on the database server in the default installation directory ..\Onyx3Server.\\. |
+ | 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 ===== | ||
+ | |||
+ | During a file backup the directories | ||
+ | |||
+ | * ..\OnyxDB and | ||
+ | * ..\Pictures | ||
+ | |||
+ | at their [[: | ||
+ | A differential backup is recommended only for the image path, while the database folder should always be copied completely. \\ | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | ++++Details| | ||
+ | ==== Backup | ||
+ | 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.\\ | ||
- | 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 | + | {{:stopservice.png? |
- | Alternatively, | + | |
\\ | \\ | ||
- | ==== Automatic Backup ==== | + | After the backup is completed, the database server OnyxDBServer must again be started manually using the Onyx3Config operating program. Alternatively, |
- | 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.\\ | + | {{: |
\\ | \\ | ||
- | 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 | + | |
+ | ==== Back up images folder==== | ||
+ | |||
+ | 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 | ||
+ | |||
+ | {{: | ||
\\ | \\ | ||
- | Recommended: | + | ++++ |
+ | ---- | ||
+ | ===== Live Backup | ||
- | * {{: | + | During a live backup, the directories |
- | * {{: | + | |
- | by an external backup tool to a mobile hard drive or rev cartridge and store the daily backup | + | * ..\Backup and |
+ | * ..\Pictures | ||
+ | |||
+ | are copied | ||
\\ | \\ | ||
- | ==== Manual Backup ==== | + | {{ : |
- | Open [[program_onyxdbserver|OnyxDBServer]] on tab |Backup/ | + | ++++Details| |
+ | ==== Backup database folder==== | ||
+ | Instead of the database folder ..\OnyxDB, the backup folder preconfigured in 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.\\ | ||
\\ | \\ | ||
- | ==== Restoring Data ==== | + | ==== Backup images folder==== |
- | Open [[program_onyxdbserver|OnyxDBServer]] on tab |Backup/Manual| as described above and start data restore by clicking | + | 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.\\ |
+ | |||
+ | {{: | ||
+ | \\ | ||
+ | ++++ | ||
+ | |||
+ | ---- | ||
+ | ===== Manual backup ===== | ||
+ | |||
+ | Open the user interface of the database program | ||
+ | \\ | ||
+ | |||
+ | ===== Data restore ===== | ||
+ | |||
+ | Open the user interface of the database program [[: | ||
^Note ^ | ^Note ^ | ||
- | |Data can only be restored | + | |Data recovery |
- | |Backup | + | |The backup |
+ | |||
+ | ===== Disable backup ===== | ||
+ | |||
+ | If you back up the server directory daily anyway as part of an external backup, you should disable the internal backup in the [[: | ||
+ | |||
+ |
en/dbbackup.1446122832.txt.gz · Last modified: 2015/10/29 13:47 by onyxadmin