On 18 April 2018 at 08:12, cicko <alen.sil...@gmx.com> wrote: > While I was using xml backend in the past couple of weeks, I finally > realized > how backup files and .log files work. I really like the scheme as, before > that, I had a script that creates backups of sqlite book in the same manner > (and deletes the .log files). > > Now, back to using sqlite book, I notice the difference: the .log files get > created but not the backup files. Is this intentional or accidental? > > I guess it is still possible to replay the .log files that contain the > missing transactions (in case of an error). Has anyone actually tried this > with an sqlite book? > > It's just that the automatic backup files are not generated. For this I > have > a Python script that does exactly the same as xml backup - it appends the > date/time to the file name and copies it to the backup folder, and keeps > the > last n copies. I should probably redo that to work based on time and keep > last n days, for example. > > Just looking to get some background info to confirm the best recovery > procedure in case of a failure. >
I suggest using the same backup procedure that you use to backup the rest of your documents so that you always have recent backups of the file. The accounts file is no different from any other important documents and data you have on your system. I use backintime [1] but there are many other options. Colin [1] https://backintime.readthedocs.io/en/latest/ _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.