Subject | Re: Restoring a multi-file database |
---|---|
Author | deschenes_jacques |
Post date | 2005-03-10T20:50Z |
Thanks Ivan and Todd for the solutions!
Jacques
--- In firebird-support@yahoogroups.com, Todd Brasseur <todd@c...>
wrote:
Jacques
--- In firebird-support@yahoogroups.com, Todd Brasseur <todd@c...>
wrote:
> The way we do this is:integrity
>
> 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
> >of the restored database without compromising the originaland
> >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
> >>>of
> >>>
> >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
> >>>
> >>>
> >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!
> >>>
> >>>
> >
> >
> >
>> [Non-text portions of this message have been removed]