Subject | Re: [firebird-support] DUP key on restore |
---|---|
Author | Tomasz Tyrakowski |
Post date | 2011-11-16T14:18:45Z |
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
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 ==--__
__--==============================--__