The Cookie Machine - Click here to drag window

DUMMY TEXT - Real text set in assets/js/theCookieMachine.js

Views: 162β€…    Votes:  2β€…
Tags: filesystem   backup   deja-dup  
Link: πŸ” See Original Answer on Ask Ubuntu πŸ”—

Title: Is there graphical backup software that is not prone to consistency problems?
ID: /2018/03/14/Is-there-graphical-backup-software-that-is-not-prone-to-consistency-problems_
Created: March 14, 2018
Upload: November 24, 2022    Layout:  post
TOC: false    Navigation:  false    Copy to clipboard:  false

Unless you are a 24/7 shop generally speaking you have the server sign everyone off at say 2am and perform backups for two hours or whatever it takes. Usually this is done in conjunction with β€œEnd of Day Processing” which rolls up detail records to Master File records, closes Month Ends, Year Ends, etc.

The basic problem is some files will β€œchange shape” if someone is adding or deleting records. Take for example ISAM (Indexed Sequential Access Method) files where there is a raw data file and then separate Index files for each key (ie Customer Number, Phone Number, etc.). If you were to say backup the Key file for Customer Numbers first, then a user added a new customer and you backed up the raw data file you would have a data integrity error.

SQL is the popular choice these days for databases in which case an SQL dump is performed without keys backed up I think. Learning SQL (pronounced Sea-Quill) has been on my to-do list for 30+ years.

Whatever your environment you have to study backup requirements carefully and test them periodically by restoring them to a test database.

Backing up programs is generally over-kill because they can be reinstalled. The exception being your own scripts you develop.

To reiterate the safest backups are those when all users are logged out of the system. When that can’t be guaranteed then professional help should be sought.

⇧ How can I print multiline output on the same line? How to access Advanced Options in GRUB?  β‡©