Subject | How to repair a database with damaged index ? |
---|---|
Author | Carsten Schäfer |
Post date | 2006-06-29T13:09Z |
Hi,
I'm using Firebid 1.5.3 on Win XP.
I have a damaged database
When i do a backup and restore of this database i get the follwing error
in ibexpert:
IBE: Unsuccessful execution caused by system error that does not
preclude successful execution of subsequent statements.
action cancelled by trigger (2) to preserve data integrity.
Cannot deactivate index used by an integrity constraint.
This happens when creating a primary key index.
When i do restore with deactivating indexes the restore gives no error.
But what are the next steps to repair the database ?
mfg
Carsten
I'm using Firebid 1.5.3 on Win XP.
I have a damaged database
When i do a backup and restore of this database i get the follwing error
in ibexpert:
IBE: Unsuccessful execution caused by system error that does not
preclude successful execution of subsequent statements.
action cancelled by trigger (2) to preserve data integrity.
Cannot deactivate index used by an integrity constraint.
This happens when creating a primary key index.
When i do restore with deactivating indexes the restore gives no error.
But what are the next steps to repair the database ?
mfg
Carsten