Subject | Problem with GBAK |
---|---|
Author | Kapil Patil |
Post date | 2006-02-15T09:55:52Z |
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
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
.\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
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
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.gbkE:\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.gbkE:\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.gbkE:\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