At 01:13 PM 5/01/2007, you wrote:

>Helen Borrie wrote:
> > Yes, you are missing something. Under Fb 2.0 there is only one way
> > to overwrite an existing database (or, in other words, to get the
> > same behaviour as gbak -r[eplace_database] in Fb 1.5.x and
> > before): you must use
> >
> > gbak -r[ecreate_database] O[VERWRITE]
> >
> > That is, gbak -REP now resolves to gbak -c[reate_database] and will
> > therefore fail if the database already exists.
> >
> > ./heLen
> >
>
>I think I am missing a lot of things :-))
>
>I have re-checked it now
>
>look:
>
>C:\Temp>"c:\Program Files\Firebird\Firebird_2_0"\bin\gbak
>c:\temp\foo.fdb foo.fbk -user sysdba -password masterkey
>
>C:\Temp>"c:\Program Files\Firebird\Firebird_2_0"\bin\gbak foo.fbk
>c:\temp\foo.fdb -r -user sysdba -password masterkey
>gbak:opened file foo.fbk
>gbak: ERROR:database c:\temp\foo.fdb already exists. To replace it, use
>the -REP switch
>gbak:Exiting before completion due to errors
>
>as expected -r fails if the file already exists
>
>Note that gbak says to use -REP switch to overwrite the file
>
>
>C:\Temp>"c:\Program Files\Firebird\Firebird_2_0"\bin\gbak foo.fbk
>c:\temp\foo.fdb -rep -user sysdba -password masterkey
>gbak:opened file foo.fbk
>gbak:transportable backup -- data in XDR format
>gbak: backup file is compressed
>gbak:created database c:\temp\foo.fdb, page_size 4096 bytes
>gbak:started transaction
>gbak: restoring privilege for user SYSDBA
>gbak: restoring privilege for user SYSDBA
>gbak: restoring privilege for user SYSDBA
>gbak: restoring privilege for user SYSDBA
>gbak: restoring privilege for user SYSDBA
>gbak: restoring privilege for user PUBLIC
>gbak:creating indexes
>gbak: committing metadata
>gbak:finishing, closing, and going home
>
>
>works, as I said on my message

Erk! It shouldn't, so your example (if repeatable) means gbak restore
is BROKEN and DANGEROUS. You had better post a high-priority bug
report to the Tracker !!!

./heLen