At 08:06 AM 7/03/2006, you wrote:

>--- In firebird-support@yahoogroups.com, Steve Wiser <steve@...> wrote:
> >
> > Are you using command line gbak to back it up? If so what is the exact
> > command you are using?
> >
>
>gbak -B -V -IG -L {source} {dest}

That doesn't look like the exact command.

What kind of partition are you writing to? If it is FAT32, you have
a 2 Gb file size limit. That what it looks like here - you need to
make multi-file backups. And note that you have to provide a full
filepath as the argument to the -L switch.

>gfix also reports the same error.

The "file size exceeded" is not an engine error, it's coming from the
operating system. (Firebird has a pre-warning mechanism, but IB 6 doesn't).

You also wrote:

> I can copy the file to a Windows server but it also refuses to open
> the database since it can not open the secondary file.

Of course. The paths to the secondary files are stored in the header
of the primary file. If you move them, you will stuff that up
because the engine can't find the secondary files. Of course, if
secondary files already exist, you must move them, along with the
primary file. But, whatever, the filespecs for the secondary files
must be valid.

Ivan Prenosil has a free tool (GLINK) to fix up the headers of a
multi-file database when you move it, see
http://www.volny.cz/iprenosil/interbase/ip_ib_download.htm

./heLen