Bob,

> > Very odd situation.
> >
> > Are the data types of the "account_id" columns the same for all tables?
> >
> > No one asked if you:
> >
> > - which FB version you are running?
> >
> > - are you performing backup/restore using the same FB version (ie. not
> trying to perform an ODS/version upgrade)?
>
> Good questions, and I should have known to provide that info:
>
> All account_id columns are defined as integer not null.
>
> I'm using FB 2.5.2.26539 64bit on Windows Server 2008 in SuperClassic mode.

That is weird.

The SQL which Karol provided should have found the problem/missing values from the Account table.

I can only think of 2 options of the top of my head:

1- Try a slightly different SQL query, though it should be the same as Karol's (Select * from zip_code_account z where not exists(select * from account a where a.account_id + 0 = z.account_id + 0)

2- Try to download v2.5.1 engine and perform backup/restore using that GBAK version.


After that you would need to drop the FKs and then retry the SQL/re-add the FKs


Sean