beautypg.com

Database management, Compact and cleanup database, Figure 41. database utility screen – Unitec Portal Owner’s Manual User Manual

Page 59: Figure 42. database compact and clean screen, 2 database management

background image

P O R T A L

Document Number:

PTL1028

Document Title:

Portal 3 Owners Manual

8.2 Database Management

Figure 41. Database Utility Screen

The Database Utility screen is used to backup and restore the Sierra Server databases. Database back up
files can be used to restore operation of the system in the event of a catastrophic event. To minimize the
potential for lost sales data, regular back-ups should be performed. The software version, date and time
of previously created back-ups are displayed on the screen.

8.2.1 Compact and Cleanup Database

The Compact and Cleanup Database function allows you to delete old transactions from the database.
This will delete old information from reports and free up memory. To compact and cleanup the database:

Figure 42. Database Compact and Clean Screen