Subject Re: [firebird-support] Backup and restore of users
Author Thomas Steinmaurer
Hello Tomasz,

> gbak -B /opt/firebird/security2.fdb ./security2.fbk
> works as well. Restoring requires two steps: restore to an alternate
> location (gbak -C security2.fbk somefolder/security2.fdb), then stop the
> server (SS) or close connections (CS) and copy the restored
> security2.fdb to the proper location in FB directory. AFAIR, a similar
> procedure is required when upgrading from pre-2.x FB (it's mentioned in
> the section "Security in Firebird 2 (All Platforms)" in "Firebird 2
> Migration& Installation" here:
> but without details).

Starting with Firebird 2, the security database can't be accessed by a
regular/direct database connection anymore. Accessing is only possible
via the Services Manager. Thus, you need to use the -se switch when
backing up the security database. At least on Windows. Can't test your
above gbak call under Linux right now.

With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

Do you care about the future of Firebird? Join the Firebird Foundation: