Rick,

> We have a database that we want to wipe and replace every week,
> regardless of whether it is in use.
> Are these the correct steps? I notice that 'gfix -online' throws an error,
> probably because the database is online after gbak completes. Is there a
> way for the restore to not become online during (I found you can connect to
> the database in the middle of a restore, which breaks the
> restore) or after gbak?

Rather than do that, have you considered:

- Create a new database with date in the filename
- write to/update FBAlias to replace the target database name with the new file name
- All existing connections will work until they disconnect
- new connection will use new database as soon as the alias is changed.


Sean