The way we do this is:

1) Shutdown Database to ensure no one is in it.
2) Copy Database
3) Backup Database
4) Restore Database

We do the copy so that we have it in case the Restore Fails.

Todd

deschenes_jacques wrote:

>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!
>>>
>>>
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
>

[Non-text portions of this message have been removed]