Maintain Database
Database Setup:
In database setup you have several options to keep your database running efficiently. The auto maintenance features allow you to archive and backup the database automatically. To set up auto maintenance, start by choosing how often you would like the database maintained. It is recommended that this be done at least once a week, however for higher volume locations daily will give you optimal performance. Then setup the time you would like this to occur. This should be down time when no one else will be using PointOS. Finally, you can set it so that other stations will have to restart after backup. This is not necessary however, restarting PointOS Professional every once in awhile can keep it running faster.

Only one station can be set to auto backup, so choose one that is most likely to be running at the time you choose. Also the backup computer must be running as a PointOS server.

The default backup location is My Documents/PointOS Professional/Backup. However, backing up to a removable media such as a external drive is preferred, in case something happens to your computer.

During auto maintenance, items and orders will be archived and credit card pre-authorizations will be deleted.


Database Setup
Manual Backup Database:
In addition to auto maintenance, you may choose to do a manual backup of the database. This would be recommended if you have just made a large change on your system. For example, if you just added a large amount of menu items, you should do a manual backup. This can be done at any time from any PointOS Server station.You may want to disconnect all stations while doing a backup. To disconnect all stations you can use the Disconnect Stations button on the Manager Dashboard.

During backup, you will be prompted for a backup location. It is recommended that you use a removable media or another computer to store your backups.

Database Utilities
Archive Orders:
Although archiving orders happens automatically when using auto maintenance it can also be done manually. This will move all closed orders from the order table to the order archive. Doing this, will have no effect on reporting and will not cause any data loss. However, you will not be able to reopen an archived order.

Archive Items:

Although archiving items happens automatically when using auto maintenance it can also be done manually. This will move all closed ordered items from the order item table to the order item archive. Doing this, will have no effect on reporting and will not cause any data loss. However, you will not be able to reopen an order with archived items.

Archive Database
Compact The Database:
When your database size get too large, this can slow down PointOS. You can recover disk space and speed up your database by clicking on Compact from the Manager Dashboard in the Database area.

When you click Compact, you will be prompted to Archive your orders and ordered items. Doing this will also speed up your system if you have a large amount of orders stored.

Compacting the database will not delete any data, and is recommend to do about once a month. However, it is always a good idea to do a database backup when ever doing any major change to the database.

Archive Database
Database Cleanup:
You can use database cleanup to remove old or unnecessary information from your system. This will reduce the size of your database, and may increase the overall speed of your system. To do this, check the boxes of the information you want to delete. Removing Logs is always a good idea, and will not affect any of the most vital reporting. After you have selected the data you want to remove, You should select a cleanup date. This is the date where all selected data from this date back will be deleted. Finally, you can choose to either delete from this date back or delete all selected data.

Deleted data cannot be recovered, so be sure you do not need it any more.

You should always make a backup of your database prior to running database cleanup.

Database Cleanup