Hi,

I do have an (rather strange) Problem with Backup/Restore:

I'm accessing the database via ADO (iboledb-provider). This does raise
an "insufficient key information" problem on the Database created by
Backup/Restore.

On the Database created by scripts or after dropping and recreating
this table (which is empty in the backup), the problem does disappear.

The Table is defined as:

/* TABLE: LehrerAbwesenheiten */
CREATE TABLE LehrerAbwesenheiten (
id INTEGER NOT NULL,
Lehrer VARCHAR(50),
VonDatum INTEGER,
VonStunde SMALLINT,
BisDatum INTEGER,
BisStunde SMALLINT,
Grund VARCHAR(255),
Nachholen BOOLEAN,
Kommentar VARCHAR(255),
PRIMARY KEY (id)
);
CREATE INDEX LehrerAbwesenheiten_Lehrer ON LehrerAbwesenheiten(Lehrer);
CREATE INDEX LehrerAbwesenheiten_VonDatum ON
LehrerAbwesenheiten(VonDatum);
CREATE INDEX LehrerAbwesenheiten_BisDatum ON
LehrerAbwesenheiten(BisDatum);
/* Vergabe der ID-Werte */
SET TERM !!;
CREATE TRIGGER T_LehrerAbwesenheiten_id FOR LehrerAbwesenheiten
BEFORE INSERT AS BEGIN
IF (NEW.id IS NULL) THEN NEW.id =
GEN_ID(ID_Generator, 1);
END
!!
SET TERM ; !!

COMMIT;

For Backup/Restore I do use "gbak" with minimal arguments (Username,
Password, DB-Name, Backup-Name).

The Database is FB1.5RC7.

What can I do to solve this problem?

Elmar