Subject Re: [firebird-support] Nbackup
Author Dmitry Yemanov
Branimir Trumbic wrote:
>
> I want to use incremental backups as my database is growing (>2Gb), I
> found that this is possible with nbackup tool (found in Firebird/bin
> directory), but I have some questions:
>
> 1. nbackup does not support (or I don't know how to set) same database
> connection string as gbak tool.
> Basically nbackup works with this:
>
> nbackup -U SYSDBA -P masterkey -B 1 localhost:C:\DATA.FDB dump.nbk
>
> but it does not work when I have firebird on different port (e.g.
> 9999), so this command does not work:
>
> nbackup -U SYSDBA -P masterkey -B 1 localhost/9999:C:\DATA.FDB dump.nbk

Why do you need a localhost prefix? NBackup is expected to work fine
without it, regardless of the TCP port of the FB server.

> 2. Another problem with nbackup is that it can not be copied to other
> location and execute from there as it excepts that aliases.conf file
> exits in directory above, it does not return any error, just
> exits...

Really? Hmmm. But anyway, why would you need a different location,
provided that nbackup should always be run on the same host, so what's
wrong with running it from /bin?

> 3. Is full nbackup database dump (-B0 option) compatible with the gbak
> dump and vice versa?

Nope, they're completely different beasts.

> 4. In nbackup manual I've found at this link:
> http://firebirdsql.org/manual/nbackup-backups.html it says that
> incremental backup is done from LAST full backup. Does this mean LAST
> full backup done by any tool (nbackup or gbak) and any client (local,
> remote)? How nbackup is keep tracking what is the last full backup?

Only nbackup, which does not work remotely. As for how it works, I'd
suggest to pay more attention to the manual. Or try it yourself.


Dmitry