At 08:55 PM 15/02/2006, you wrote:

>I have the backup copy of Firebird Database (Size: Exceeds 4 GB)
>
>Now I used GBAK to split & Create New Database into 5 parts each 2 GB Size
>
>===================================================
>Following Syntax I used to split the database
>
> >gbak -c -v -g -p 8192 -user user1 -password pass1 E:\backupdb.gbk
>E:\db0.gdb 262144 E:\db1.gdb 262144 E:\db2.gdb 262144 E:\db3.gdb
>262144 E:\db4.gdb 262144
>
>===================================================
>
>This command works BUT THE PROBLEM IS THAT THE SECONDARY FILES CREATED
>ARE SENSITIVE TO ACTUAL PATH. IF I MOVE THE COMPLETE DATABASE
>(including secondary files) TO D:\ AND THEN TRY TO CONNECT, THE SERVER
>GIVES ERROR FILE: 'E:\db1.gdb' ........ not found
>
>I WANT THE SECONDARY FILES SHOULD HAVE THE RELATIVE PATH WITH THE MAIN
>GDB AND NOT THE ACTUAL PATH.
>
>SO I TRIED THE FOLLOWING SYNTAX
> >gbak -c -v -g -p 8192 -user user1 -password pass1 E:\backupdb.gbk
>E:\db0.gdb 262144 .\db1.gdb 262144 .\db2.gdb 262144 .\db3.gdb 262144
>.\db4.gdb 262144
>
>but no use it creates the db0.gdb in E:\ but remaining files are
>created in C:\Documents And Settings\Administrator
>
>SO I TRIED ANOTHER SYNTAX
> >gbak -c -v -g -p 8192 -user user1 -password pass1 E:\backupdb.gbk
>E:\db0.gdb 262144 db1.gdb 262144 db2.gdb 262144 db3.gdb 262144 db4.gdb
>262144
>
>but no use it creates the db0.gdb in E:\ but remaining files are
>created in C:\Windows\System32
>
>=================================================================
>I want the Main gdb & Secondary files in the same place & should be
>relative to the path so I can easily move them from one drive to
>another
>
>Thanks In Advance

The reason you can't do this with relative path addressing is that
the absolute paths for the secondary files are stored in the header
of the database, in the primary file. Since it's possible to spread a
multiple-file database across multiple disks/partitions, it wouldn't
make sense to use relative path addressing.

Ivan Prenosil has a free tool called GLink for adjusting the headers
when you want to move a multi-file database:
http://www.volny.cz/iprenosil/interbase/ip_ib_download.htm

Read Ivan's instructions.

And thanks in advance for NOT SHOUTING AT US IN UPPER CASE next time
you post here.

^ heLen