Subject Re: How do I backup FB 2.0 security2.fdb?
Author red_october_canada
> Try TIBBackupService component (from InterBase Admin page)

Thanks Ivan


Hey, I made a little utility in D7 to accomplish this, using the
suggested component, and it works ok.

However, I stumbled upon

http://www.destructor.de/firebird/gbak.htm

which states that I can use gbak with the -se dbserver:service_mgr
option to accomplish the same thing. However, I can't make this work.
I substitute "dbserver" with "localhost" and come up with a command
string like this:

gbak -v -t -user sysdba -password bubbles -se localhost:service_mgr
"C:\Program Files\Firebird\Firebird_2_0\security2.fdb"
"C:\firebird_bk\Security2.fbk"


This always gives me the error: I/O error for file "C:\Program"

I tried this also:

gbak -v -t -user sysdba -password bubbles -se localhost:service_mgr
"127.0.0.1:C:\Program Files\Firebird\Firebird_2_0\security2.fdb"
"C:\firebird_bk\Security2.fbk"

This produces the error:

Connection rejected by remote interface.

-----------------------------------------

SOLUTION FOUND:

I just made an alias (sec2) in the aliases.conf file that points to
the security2.fdb and changed the command to:

gbak -v -t -user sysdba -password bubbles -se localhost:service_mgr
sec2 "C:\firebird_bk\Security2.fbk"

It now works fine. So much for my little D7 utility <tears,sniff>

I hope no one minds me posting the complete solution here, for anyone
who may have run into this too.