Subject | How check if database iscorrupted: backup/restore or validation |
---|---|
Author | Roberto Vieweg |
Post date | 2019-11-13T20:35:23Z |
I'm developing a new updater for my application that uses a Firebird database.
My old version was using the gbak tool for backup and restore the
database (in a secondary FDB). If the backup and restore was finishing
with success, I acsume that the database integrity is OK.
The problem is that this approch consumes a lot of time in large databases.
So my question here is:
Can I run a database validation (gfix -validate -no_update) and acsume
that the database integrity is OK when this command finishes without
errors ?
In this case I'll only perform a backup for rollback the update in
cases of errors.
My old version was using the gbak tool for backup and restore the
database (in a secondary FDB). If the backup and restore was finishing
with success, I acsume that the database integrity is OK.
The problem is that this approch consumes a lot of time in large databases.
So my question here is:
Can I run a database validation (gfix -validate -no_update) and acsume
that the database integrity is OK when this command finishes without
errors ?
In this case I'll only perform a backup for rollback the update in
cases of errors.