Subject Re: [firebird-support] DUP key on restore
Author Leonardo Carneiro
Hi Tomasz. I already checked the source database for duplicated entries,
and found none, but i did not tried to verify the database with gfix.

Tks for the tip!

On Wed, Nov 16, 2011 at 12:18 PM, Tomasz Tyrakowski <
t.tyrakowski@...> wrote:

> Hi,
>
> Check for duplicates in the source database with all indices and primary
> keys on problematic tables removed. Also, verify the source database
> with gfix. If there are index page errors, you may get false results
> when you check for duplicate records.
>
> regards
> Tomasz
>
> On 2011-11-16 13:18, Leonardo Carneiro wrote:
> > Hi everyone,
> >
> > I have a database, running on Firebird 2.1.3 32bit on Windows XP. I did a
> > transportable backup and i'm trying to restore it in a Windows Server
> 2008
> > R2 with Firebird 2.1.4 64bit, using IBexpert.
> >
> > The restore is OK, but some indexes are not being activated cause there
> > exist some duplicated entries in some table. This is odd, because in the
> > source database there is no DUP keys (i double checked).
> >
> > Anyone know why this is happening? Should i provide any aditional info?
> >
> > Tks in advance.
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
>
>
> --
> __--==============================--__
> __--== Tomasz Tyrakowski ==--__
> __--== SOL-SYSTEM ==--__
> __--== http://www.sol-system.pl ==--__
> __--==============================--__
>
>


[Non-text portions of this message have been removed]