FirebirdSQL logo

-⁠TR[USTED]

Use Windows trusted authentication (Win_Sspi).

Note
Introduced in Firebird 3.0.

-⁠USER

Username for authentication.

Syntax
-USER username

Allows the username of the SYSDBA or database owner user to be specified if the database is to be backed up, or, in the case of a restore (with the -⁠c[reate] switch specified), any valid username can be specified.This need not be supplied if ISC_USER environment variable exists and has a correct value for the username.

Databases can only be backed up by SYSDBA, users with the RDB$ADMIN_ROLE, the database owner, or — since Firebird 4.0 — users with the USE_GBAK_UTILITY system privilege.A restore can also be carried out by SYSDBA or the database owner, however, if the -⁠c(reate) switch is used, any authenticated user can create a new database from a backup file.In Firebird 3.0 and higher, non-admin users need the CREATE DATABASE DDL privilege to be able to restore a database.

-⁠V[ERIFY]

Display information on the backup or restore.

Normally gbak operates quietly with no information written to the display.This switch reverses that situation and causes lots of information to be displayed.The default is to display the output to the screen, but you can redirect the output to a log file using the -⁠y switch.

This option is mutually exclusive with [gbak-cmdline-verbint].Using -⁠verify is the same as specifying -⁠verbint 10000.

Caution

Contrary to its name, this option doesn’t verify anything, and it would have been better named -⁠VERBOSE.

The only way to verify a backup is to restore it, check it doesn’t complete with errors, and maybe perform some queries for sanity checking

-⁠VERBI[NT]

Verbose information with explicit interval.

Syntax
-VERBI[NT] interval

The interval controls at how many records written gbak will output information;in other words, it controls the frequency of the output of “…​ records written” messages.The minimum value is 100.

This option is mutually exclusive with [gbak-cmdline-verify].Using -⁠verify is the same as specifying -⁠verbint 10000.

Note
Introduced in Firebird 3.0.