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: > http://www.firebirdsql.org/file/documentation/release_notes/html/install210.html > 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 http://www.upscene.com/ Do you care about the future of Firebird? Join the Firebird Foundation: http://www.firebirdsql.org/en/firebird-foundation/
