What I meant was

- make backup to backup_path,
- restore to original_path but under different name,
- if it succeeds, drop original database and rename
first file of new database only

or if you do not have enough space for it

- make backup to backup_path
- restore to restore_path to verify it,
- if it succeeds, drop original database
and restore it again to original_path

or just copy database files from restore_path
to original_path as you proposed, and use this tool
to modify primary file's header to point to correct
path/file name:
http://www.volny.cz/iprenosil/interbase/ip_ib_download.htm

(tested only on Windows, but it is written in plain C
without using any Windows-specific features,
so you should be able to compile it.)

Ivan

----- Original Message -----
From: "deschenes_jacques" <deschenes_jacques@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, March 10, 2005 4:34 PM
Subject: [firebird-support] Re: Restoring a multi-file database


>
>
> I restore to a restore_path because I want to verify the integrity
> of the restored database without compromising the original
> database. If errors occurs during the restore, I still have the
> original database to go back to.
>
> Yes, I need a multi-file database because of a 2Gb. limit.
>
> Jacques
>
> <Ivan.Prenosil@s...> wrote:
>> Why do not you restore the database directly to the original path
>> instead of copying it there ?
>> Do you need multifile database at all ? (I don't know hp-ux)
>>
>> Ivan
>>
>>
>>
>> > I run Firebird version "HU-V6.2.972 Firebird 1.0.3" on a HP-UX
>> > server.
>> >
>> > I have a 3 Gb. multi-file database (file.gdb, file.gd1) that I
> want
>> > to restore onto another path on disk so I can verify its
>> > fonctionnality without compromising the original database:
>> >
>> > . assures that no process/users is connected to the database and
> put
>> > the database offline
>> >
>> > . gbak -b original_path/file.gdb backup_path/file.gbak
>> >
>> > . gbak -c backup_path/file.gbak restore_path/file.gdb 500000
>> > restore_path/file.gd1
>> >
>> > After verifying the integrity of the restored database, I want
> to
>> > copy it back in the original path. As I understand, the path of
> the
>> > restore_path database second file is stored in the database
> itself.
>> > How can I copy the two files to the original path with the
> secondary
>> > file pointing the the original_path ?
>> >
>> > Thanks!