Was that backup in transportable format?
Gbak complains with 'gbak: ERROR: expected backup description record'

N

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Ryan Thomas
> Sent: Tuesday, 12 July 2005 8:49 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Duplicate Primary Keys
>
> Hi all,
>
> I came across this database this morning. It belongs to a
> client of ours who was reporting some errors when using our
> software. On inspection of the database the table in question
> seems to have duplicates in the primary key column.
>
> Has anyone ever seen this before, or do they know of how it
> could occur? The table does not have any foreign keys and the
> database is generally only accessed by the one connection.
>
> I have made a copy of the database available, however all of
> the triggers / stored procedures / views and non-related
> tables have been removed. The only table in the database is
> titled MBUSERCOMPANY, if you look at the row where
> COMPANYNAME is 'Seaside Home Loans' you will see that there
> are two entries both with the same key.
>
> The database zipped down to ~3Mb, I tried doing a
> backup/restore on it but the restore failed with an integrity
> check error (the duplicate PK).
>
> Here's the database:
> http://www.transactive.com.au/dup_pk.zip
>
> Any insight into this would be great.
>
> Cheers,
>
> Ryan Thomas
> TransActive Systems
>
> P: (02) 4322 3302
> F: (02) 4325 1141
> E: ryan@...
> W: http://www.transactive.com.au/
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources
> item on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
> __________ NOD32 1.1166 (20050711) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>