♫ And it’s too late baby now, it’s too late; though we really did try to make it. Something inside has died and I can’t hide and I just can’t fake it…♫

So go some of the lines of the old Carole King hit from 1971. Unfortunately, that pretty well sums up the situation for those sad contemporary souls who have computer crashes, but didn’t have their databases backed up on a regular, frequent basis. The part about “I just can’t fake it” is especially true after “Something inside has died” (that is, inside of the computer). When you lose your database or databases, there’s just no faking it.

If you are like most, you get a sick feeling inside just thinking about it, and you resolve to get started soon at making a habit of backing it all up. Procrastinate no longer, friend. Get help from your I.T. department, or if you don’t have one, there are numerous players now, that for a small fee, will back up and protect your important data, either locally or in the cloud.
Don’t wait until you are singing the old Carole King song, “It’s Too Late”. Go ahead and protect yourself.

by Trent Phillips CRL CMRP - Novelis

You should regularly back up any active database to guard against data loss and to protect the investment made in your database design. A backup allows you to easily restore an entire database without the hassle of rebuilding everything from scratch. Backups help protect a database from system failures and help protect against mistakes. As the size of your database grows,  you should consider archiving the older data. Archiving is the process by which you periodically move older records from one database to an archive database. If you want to automate creating backups of database files,  consider using a product that performs automated backups of a file system, such as file server backup software or a USB external backup device. To decide how often to make backups, consider how often your database changes: • If your database is an archive, or if it is used only for reference and rarely changes, you should make a backup every time that your data changes. • If your database is active and your data frequently changes, you should back up your database on a schedule. The more active the database or greater the number of changes, the more often you should schedule the backups. The easiest way to back up an OMNITREND database is to use the copy and paste function within Windows Explorer. Locate your Access database within Windows Explorer and left click on the file to highlight it; next right click on the file and select copy. While in Windows Explorer navigate to the location that you would like to copy the database and right click on the location and select paste. You have now created a backup of your database. If you are uncertain as to where the database file is located; open OMNITREND and the top bar will inform you of the location and name of your database. OMT imageIt is recommended that the backup database be stored on a different computer as the original. If that computer crashes it will result in the loss of both the original and the backup database. A few suggestions as to where to store a backup database would be a CDROM/DVD, USB stick, network drive, the cloud, or another computer.

by Mickey Harp CRL