Loading a "dump" file from one box to another box

Hi there,

How do I specify in my sql statement to load a database using a dump file from another box?

for example if I am using boxA with a database named myDB_A and I want to load this database, the following is the statement (this is done thru dos and loggin into via isql and providing a sql file with the below statement in that sql file)

load database myDB_A from "compress::/sysbasedumps/filename.dump"

the above is fine as the "filename.dump" resides on the same box as the database.

but my query is how do i specify in my statement to say ... "get the filename.dump from another box"

I tried doing this but it failed

load database myDB_A from "//boxB/compress::/sysbasedumps/filename.dump"

assume that boxA and boxB have the same directory structure.

any idea why it is failing? thanksStart Free Trial