Subject Re: [firebird-support] Gbak utility
Author Stefan Heymann
> To summarize:
> Fill database
> Set index (takes about 6 hours)
> Create backup (which removes index)
> Create database from backup (which adds the index, again 6 hours)

> So the index is created twice.
> Is there a way to improve this? F.e. by putting a inactive index in
> the database that gets activated at the create database from backup?

You can use GBAK -i and all indexes will be restored as INACTIVE. So
you can start to work with the application and activate the indexes in
parallel.

You can also use the GFIX -mo[de] read_only switch to set an existing
database to read-only-mode.

Regards

Stefan