Repair Database

This option closes PizzaGest and opens the Database Repair program, which checks the database and rebuilds it from a backup made at that moment.

How to get here: menu Help → Repair Database.

The option only appears on the server (or on the franchisee station) that has the database on the computer itself.

When you click the option, PizzaGest closes. The repair program also closes the printing service and the fingerprint program.

Repairing the database

1. Click Repair Database.
2. Answer Yes to the question "Do you want to repair the database?".
3. Wait for it to finish. The program writes each step on the screen.

These are the steps it carries out:

1. It closes the programs that use the database.
2. It restarts the database engine.
3. It checks that the database exists and validates it.
4. It makes a new backup of the database. If there was already one from a repair on that same day, it deletes it first.
5. It restores the database from that backup.
6. It runs some additional checking processes.

If everything goes well, the messages "Process completed successfully." and "The database has been restored successfully." appear, and the program closes. Then open PizzaGest again.

If any step fails, the line appears with the word ERROR: and a message explains the reason.

If "The database is locked." appears, close all the programs that are using it. If it stays the same, restart the computer and try again.

Buttons

• Repair Database: carries out the repair.
• Restore Backup: restores the database from a backup file you choose. It asks for a password given by technical support.
• Close: closes the program without doing anything.