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
