How to backup a remote Firebird SQL database using GBAK
The following BAT file may be of interest if your local machine is not too far away from the database server. It shows how to use the free GBAK utility to backup a remote Firebird SQL database, with the destination file landing locally.
This BAT syntax is for use on Windows.
This BAT syntax is for use on Windows.
:: backup-sample.bat setlocal set project=sample set yyyymmdd=20191020 set fbroot=d:\Apps\FirebirdSQL\2.5\bin\ if NOT exist %fbroot%bin\gbak.exe ECHO "cannot find %fbroot%bin\gbak.exe" if NOT exist %fbroot%bin\gbak.exe pause :: define target folder set bakdir=c:\fbtemp\ mkdir %bakdir% cls :: FYI syntax for the source when db is local set DBName=c:\santral\data\santral.fdb :: syntax for remote db using alias, server:alias set DBName=sql332.href.com:sample01 set u=SYSDBA set p=masterkey REM gbak-user -password
Comments