Hi,

> I want to take a backup of a file which is around 2 GB and I want 650 MB backups. (On Windows)
> I tried this on a machine different from the on where the server is running.
>
> gbak -b -user sysdba -pass masterkey server:d:\directory\database.fdb d:\bkup\file1.gbk 650m d:\bkup\file2.gbk 650m and
> so on and it did not work. It created the three files but once the first file reached 650m gbak exited saying insufficient space.
>
> then i tried
> gbak -b -user sysdba -pass masterkey server:d:\directory\database.fdb stdout | fsplit 650000000 d:\bkup\file1.gbk
> d:\bkup\file2.gbk
>
> That did not work either
>
> So what is the syntax?

You need to be aware of two things.

- If you are executing gbak.exe from a client, and the backup file(s)
should be stored on the server, then you have to use the Services
Manager by using the -se switch with something like:

gbak -b -user sysdba -pas masterkey -se server:service_mgr
/yourdatabasefile.fdb /file1.gbk ....

- Omit any file size restriction for the last backup file,
so that it can exceed if necessary.

The following should work:

gbak -b -user sysdba -pass masterkey server:service_mgr
d:\directory\database.fdb d:\bkup\file1.gbk 650m d:\bkup\file2.gbk 650m
d:\bkup\file3.gbk

Always omit any size restriction on the last backup file


Best Regards,
Thomas Steinmaurer
LogManager Serie - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com