Subject | Nbackup |
---|---|
Author | Branimir Trumbic |
Post date | 2008-11-13T08:43:08Z |
Hi,
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
gbak executes "localhost/9999:C:\DATA.FDB" without problem
Is there any way to connect to the Firebird database on custom port
with nbackup?
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...On other hand, gbak can be copied (along with fbclient.dll
msvcr71.dll, msvcp71.dll) to another location (computer) and executed
as standalone application.
Is it possible to use nbackup as standalone application?
3. Is full nbackup database dump (-B0 option) compatible with the gbak
dump and vice versa?
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?
What if backup is executed from another machine through TCP/IP or
something like that. With this in mind I can only think to keep my own
'last full backup tracking system', to know what last backup to use
when restoring database with nbackup tool.....
All tested on newest release: Firebird-2.1.1.17910-0_Win32.zip on
Windows XP
Thanks,
Branimir
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
gbak executes "localhost/9999:C:\DATA.FDB" without problem
Is there any way to connect to the Firebird database on custom port
with nbackup?
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...On other hand, gbak can be copied (along with fbclient.dll
msvcr71.dll, msvcp71.dll) to another location (computer) and executed
as standalone application.
Is it possible to use nbackup as standalone application?
3. Is full nbackup database dump (-B0 option) compatible with the gbak
dump and vice versa?
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?
What if backup is executed from another machine through TCP/IP or
something like that. With this in mind I can only think to keep my own
'last full backup tracking system', to know what last backup to use
when restoring database with nbackup tool.....
All tested on newest release: Firebird-2.1.1.17910-0_Win32.zip on
Windows XP
Thanks,
Branimir