Database Validation & Repair
|Previous Index Next How To Use|
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 Workbench does not perform this validation, nor does it repair anything. This is "just" a visual interface to build-in Firebird functionality.
•Only the first and only connection to the database can perform a validation & repair cycle.
•This only works for Firebird SuperServer.
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.