Database Validation & Repair
|Previous Top Next|
Sometimes is useful to analyze your database integrity - Firebird can do this for you via the command-line tool "gfix". Database Workbench offers a visual interface to the same functionality.
You can reach Database Validation & Repair via the context menu Administration & Maintenance | Database Validation & Repair.
Database Validation & Repair Wizard
Database Validation and Repair is a two-step process:
The wizard will guide you through this process.
1. Database Validation
Next is the "Validation Options" page - this page holds the options as described in the Firebird documentation. Using the Validate! button will start the validation process.
After validation has completed, Database Workbench will show you the result of the validation process - if any errors come up, it will also enable the next wizard pages, the ones for Database Repair.
Errors were found during the validation process
2. Database Repair
After errors were found and you have clicked the Next button, the repair options will be shown.
Database Validation & Repair Wizard - repair options
By using the Repair button, Database Workbench will start the repair process and a report will be available when it's finished.