Commented by: @dyemanov

Backup and restore are not expected to work remotely. You need to execute NBACKUP on the server machine and specify a local connection strings (without host name) for the database.

Commented by: Elmar Knoerzer (knoerzer)

Hi Dmitry,
what do you mean with local connection string ?

I have read this in the manual, but i_am not sure, waht is a local connection string.

if i try
Nbackup -user sysdba -pas masterkey -B 0 c:\fb2\db\bj\bj.fdb bj0.nbk or
Nbackup -user sysdba -pas masterkey -B 0 bj bj0.nbk (using alias)
i get the failure PROBLEM ON "attach database".
unavailible database
SQLCODE:-904
Failure : Database error.

Commented by: @dyemanov

"unavailable database" usually means that you have a mismatch in server and client versions, e.g. if you use fbclient/gds32 from FB1.5. Make sure you have the proper client library in the path. Also, you should be able to use "localhost:<pathname>".

Commented by: Elmar Knoerzer (knoerzer)

I have deleted all fbclient/gds32 found on the system,
reinstallation of Server.

Nbackup -user sysdba -pas masterkey -B 0 c:\fb2\db\bj\bj.fdb bj0.nbk or
Nbackup -user sysdba -pas masterkey -B 0 bj bj0.nbk (using alias)
does not work.

Nbackup -user sysdba -pas masterkey -B 0 localhost:c:\fb2\db\bj\bj.fdb bj0.nbk
works !

Commented by: @dyemanov

It works for me with both local and localhost connection strings, so everything is as designed. As for the Elmar's issue with local connection, it's related to Win2003 which runs the terminal services by default and this mode prevents the FB local connections.