David J Murray Dev
~ Learn and Do - Excel and Share ~


Jun 20, 2006

One of my clients backs up their UniVerse database using a windows based backup utility. This makes the backup process rather simple, and as it is done after hours when no database activity is happening, data and file integrity is OK.

But as I found out this week, this method of backup does have one rather large disadvantage. No database integrity is ever performed.

I decided to change the backup method due to the client wishing to change the operational aspects of their system – they are considering a 24/7 operation.

I changed the backup method to using the uvbackup utility – saving to a predefined directory which will be backed up via the windows based utility. Restoring will consist of restoring the uvbackup file and then using uvrestore to extract the necessary accounts, files and items.

While testing, what I found was database corruption in the main operational account. As a complete database scan/backup had never been performed (the windows backup utility does not understand the file structure of UniVerse) this corrupted file had never been found.

After fixing the file, all is OK.

I have now changed the backup method to use a bunch of windows cmd files which save each working UniVerse account on either a daily or weekly basis. Then I get a email of the uvbackup log file for checking.

Next will be the implementation of transaction logging. Fun oh…

About the Author

<a href="https://davidjmurray.dev/losucag/davidjmurray/" target="_self">djm</a>


I have been in the computer/IT industry for over 35 years. After spending half a life-time in highly proprietary database environments, I have succumbed to the WordPress Eco-system and I'm well down the chasm. I am specializing in AWS hosting, Wordpress CMS, Elegant Themes, in particular Divi and Extra themes.


Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Pin It on Pinterest

Share This