Backing Up Your CRE or RPE Database

If you are using Cash Register Express (CRE) or Restaurant Pro Express (RPE), you need to back up your database on a daily basis.


As the owner or manager of a retail store, it is your responsibility to make these daily backups.


You have several scenarios to figure out.


What happens if your server computer (the computer that holds your data) fails?


What happens if your computer is stolen?


What happens if you have no electricity?


Today, let's just talk about the safety of your data. You have thousands of customers and hundreds of thousands of transactions. Your data includes your price lists, complete inventory, customer history and all sorts of other important data stored in your cre or RPE database.




Backing up your database to a flash drive or other portable device is fairly easy. No matter what your level of computer expertise, you should learn to do it. You should do it every day. Stick that flash drive into your pocket and bring it home with you.


Go here:


Backing Up Your Database (Video)


This is the PCAMERICA video that will help you learn to back up your database.


 ... or read the written instructions at:


Backing Up Your CRE or RPE Database (Document)


Some additional information related to your backups:


When you back up your database, you need to create a name for the database you are backing up. Since you are doing this on a daily basis, it should be a unique name such as CRE05142013, CRE05152013 or other unique name of your choice.

It is likely that your CRE or RPE database is less than 4 GBs. You can purchase a 16 GB flash drive at Staples (for example) for less than $10. At this price, you can buy one portable flash drive for each day of the week.


You should be making a unique backup each and every day. How many days of backups do you need? That's up to you. I think a 7 day back up routine is all you need and see no reason why you would need to go back in time by more than 7 days. Remember, your CRE/RPE database contains your entire business history. Having more than a 7 day backup history won't add any more safety.


You can do even more. Should your server computer fail, what do you do? I always recommend that retail stores have a redundant server. Most retail stores don't do this. It means purchasing an additional computer that just sits there. At the end of the day, you can make an additional backup to your redundant server. Should your primary server fail, your redundant server is ready to take over.


Depending on how you do it, a redundant server will cost your an additional $2,000 or so including installation. A computer professional can set up a raid system for you. This will constantly synchronize your two servers. Should one computer fail, you can still be in business using that second server.


Your most important task is to make sure that you have at least a daily backup of your database. As the owner or manager of a business, you need to make sure that this happens. If you have any questions or problems related to performing this task, you should call PCAMERICA Tech Support.