Subject Re: [firebird-support] upgrade to firebird 2.0
Author Helen Borrie
At 10:04 PM 20/02/2008, you wrote:

>Hello everybody,
>
>I have a Database in firebird 1.53 running under linux platform. Now i
>am trying to upgrade my db into firebird 2.0(windows). I took a backup
>and restored it in FB2.0. restoring was completed successfully, when i
>look into the db i found all indices are in inactive mode, how can i
>make active those indices ?
>anybody can help me ?

It looks as though either a) you didn't allow the restore to complete or b) you restored it using the -i[nactive] switch.

Either way, the easiest way to fix this is to re-run the restore but this time use the -v[erify] switch and watch for the completion message "...going home.." Don't use the -i switch unless you *mean* to restore with indexes inactive.

./heLen